3 Replies Latest reply on Jul 17, 2016 1:16 AM by twelvetens

    Date Format Different When Hosted

    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?