I guess it's not a bug but a user error.
What does the date look like on a swiss computer? Does it have dots there or slashes?
If it has slashes, get the computer set right. If it has dots - as I assume - make and open a clone of your file on that very computer and check the date format. Then import the data from the old file.
I mean the date on the computer as such, not in FileMaker!
nice to hear from you and thank you for the tips.
As soon as the swiss computer is free I'll try it. Once I've tested that, we can disuse what exactly one needs to do to get the computer "set right".
I don't think it is a user error - but that's what one always thinks, so I am willing to wait and see what the test results show.
OK - test complete - with VERY BAD RESULTS!
I am afraid that it is NOT a user error. That would have been the best option! It really is a FileMaker BUG on Mac-Systems!
On a Macintosh Computer with Swiss settings FileMaker interprets the date delimiter incorrectly, using a slash instead of a dot:
- Any FileMaker database opened on such a mac with "Use Formats from System" will always incorrectly show a "/" in dates instead of dots.
- Any FileMaker database created/cloned on such a mac stores the incorrect "/" delimiter in the files format-settings.
- If this file is opened on a windows system and the option "Use Formats from File" is selected, the incorrect delimiter is even regurgitated on the windows system.
- Swiss mac users cannot create a FileMaker database which shows dates correctly, without having to initially create every file on a windows computer!
- In order to convert a functioning database for swiss mac users it is essential to convert the database using a windows computer with swiss regional settings.
Windows works fine. Congratulations buddies!
I'm logging this one as a bug.
Feel free to try it for yourself!
Greetings from a land with dots and commas that work
Problem tested on Mac OSX 10.7.5 and occurs in both FM11 and fmp12
Tested this as well. It's a little bit more complicated.
1. Clone does not take over System Settings.
2. Freshly created file (New Database ...) does.
Multilingual FM Advanced 11v4, most recent OS X 10.7, both language and input format set to "Schweiz (Deutsch)". Usually I set language to English and input format to "Switzerland (German)"
See also this discussion https://www.filemaker-magazin.de/forum/beitrag/87131
The reason might be this old KB article http://help.filemaker.com/app/answers/detail/a_id/189/
which was applicable for FM7, but who knows, maybe also for later versions?
Swiss use decimal point both for date and number separator, and colon for time separator.
Personally, I have no problem with how date and time are stored internally, as long as they can be formatted for display.
Hey..Mr Winfried..tested it myself..They may have to impliment these settings in order to work with the Mac system.
At least it works on Windows. Russell has identified an other bug in FileMaker.
top! Thank you very much for this entry, the KB-Article is exactly at the root of the problem!
I have thus registered this problem as a (multiple) bug - still present in fmp12!
We'll see if it helps.