FileMaker Pro 7: wrestling with when File and System Date and Time Formats are different
Originally posted on my iBlog 6 January 2005.
Summary: Like a lot of good software, FileMaker Pro is designed in the US. As such, it is built in a world of such wacky standards as US Letter page size and a date format that goes month/day/year. FileMaker databases seem to take on the date format of the computer on which they were built, which means US format for the default templates. As a kiwi who uses a sensible, hierarchical date format, this can cause a few problems. Here's how I get around this.
If you get a warning each time a database is opened, saying the system and file date and time formats are different, it is because the system settings on the computer at the time the database was created differ from the current settings.
For example, this has happened to me with FMPro databases I made while in the US but now use in NZ. I've discovered in FMPro7 (and it may apply to earlier versions also) that all the templates that come with the program were made in the US and so have the wacky US date system built in as their default. I get the warning every time I open such a file, which is hardly ideal! One fix, from FMPro Help, is to force the database to always adopt the System settings of the computer it is being opened on, without asking. To do this, Select File:File Options. In the Text window, there are options for Data Entry when current System settings differ from saved settings. Click to use "Always use current system settings".