Since hosting on FMS12 my dates are returned in different format
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?