AnsweredAssumed Answered

Since hosting on FMS12 my dates are returned in different format

Question asked by philmcgeehan on Dec 2, 2013
Latest reply on Dec 4, 2013 by philmcgeehan

Title

Since hosting on FMS12 my dates are returned in different format

Post

     I had a script that worked, where I could select a month from a pop-up list and it would display a list of records from that month.

     Originally it would set $filterdate to DD/MM/YYYY
     Then search for all the records within that month.

     Then I purchased FMS12 and now access the database over the LAN via our server.

     But, now it sets the $filterdate variable to MM/DD/YYYY
     now when it searches for the date it doesn't get the correct results, because the Month and Date are mixed up.

     I'm in the UK and I want the format to be DD/MM/YYYY
     My computer and the Servers date settings are set to DD/MM/YYYY

     Is there any other date setting somewhere that I have missed, or do I need to swap the DD and MM around in my script?

Outcomes