Can the Drop-down Calendar field be saved as DD/MM/YYYY instead of the default MM/DD/YYYY?
I'm using FMPro 14.
System and locality settings will control whether you enter the month or the day first when typing in a date, but the date entered into a date field is ultimately stored as the number of days from 12/31/0000 to the date you enter. Whether you see DD/mm/yyyy after you exit the field will depend on how field formatting displays the data in that field, but the internal value is the same.
So clicking a day in the pop up calendar will enter the same value regardless of field format, locality or system settings.
Does your Date Field with Drop Down Calendar look like this?
In regards to the Date Format, what Data Formatting have you used in the inspector?
mine shows as er screenshot:
No option for DD/MM/YYYY.
What format is your operating system's date format in?
FileMaker references the system settings of your computer. (See Phil's post).
Thank you very much, philmodjunk!
you're right. Changing the system's date format resolves my problem
Thank you, Michael, too!
Retrieving data ...