AnsweredAssumed Answered

Date Format Different When Hosted

Question asked by twelvetens on Jul 16, 2016
Latest reply on Jul 17, 2016 by twelvetens

Hi,

 

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 "?"

 

Notes:

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.

 

Questions:

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?

Outcomes