Date formatting in FileMaker | Learning Claris FileMaker | Scoop.it

The importance of localization


Date settings in Europe and in the States, for example, are different. 


The specification “01.10.2020” is interpreted in Europe as “October 1st, 2020”, however, in the States as “January 10, 2020.” 


In order that FileMaker knows how to understand a date specification, the local information is anchored as a fixed specification in the file when a file is created. 

On one hand, this allows an interpretation of the date, but should the file open later on another operating system, FileMaker can match new date entries (between system settings and the information anchored in the file). 

This ensures the integrity of various date entries.


Read more on the blog