I've got a scripted process generates a timestamp in the format DD/MM/YYYY HH:MM:SS as a variable. It then pastes this value into a TimeStamp field.
When I run this script on a file that's opening locally, it all works fine.
When I upload the file to Filemaker Server ON THE SAME MACHINE, it fails, and the timestamp field just shows a "?"
The locality of the machine is set to use UK format (DD/MM/YYYY).
The file is set to use System Settings for date formatting.
Host machine is OSX 10.11.X FMSversion 14.x
If I change the script to paste the variable into the timestamp field in the format MM/DD/YYYY it all works OK again, but I'm concerned when other users run this script from other machines where I don't have control of the locality settings.
Is there some kind of setting within Filemaker Server for date formatting that could be over-riding the file and OS settings?
Am I losing my mind? I can hardly believe this is happening. Surely Date formatting should be taken care of by the File Settings?