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?