FileMaker not accepting ISO 8601 compliant manual date entry

While FM can display dates in conformance with ISO 8601, using custom formatting, it does not accept manual date entry in said format.
How do you get around this issue in the user interface of your solutions?

Enter it with + instead of -

2022+01+17 works

1 Like

Or script trigger OnObjectValidate with field name as parameter and then
set field by name with substitution from "-" to "+"

That way the script is universally usable.


I think this is tied to the regional settings of the machine the file was created on (or of a machine where you open a clone and then import records). There are options to allow local settings when they are different than the one of the file. Perhaps you can look into that also.

1 Like