Return to FileMaker.com
Year only date format
We have a field "Year Manufacture" and we want to force 4 digit entry (1999, 2000, etc.).
Can we either format the field as 'Date' and allow only year entry (no day, month) or format for number and force 4 digit entry?
You could keep it as a date field and cause it to only display the year. This still requires entering a month and day. It just ignores them for display purposes.
Or you can specify a number and set up the limits that you want using either Field Option validations and/or a script performed by the OnObjectValidate trigger.
Retrieving data ...