|
Hello there, I'm trying to use a create unit with YEAR datatype from MySQL, however I can only choose DATE as the type of the field. I tried to use a "Validation Rule" with a format of YYYY, however when I use the form to enter data, it appears the message: "the entered value should have the format M/d/yy" Also, when using DATE as the type of the field, a calendar of day/month/year appears. Bottom line: I want to use a create unit with a year field only. Is that possible? Thank you! |
|
Hi, at this moment the YEAR datatype from MySQL is not supported. However if you want to menage the years I suggest you to follow these alternatives:
Moreover if you consider the second alternative you can use the Calendar input and add the required validation Rule (i.e. a Regular Expression with (19|20) as value of the Expresssion Property). In order to define subtypes you can refer to the steps described in the answer of this post: Format currency Here you can find more details about the Validation Rules: The Validation Rule Framework |
