US Date Default on Web Server

Hi Everyone,

Here's my problem.

I have a coldfusion form which requires the users to select from list boxes start and end dates. These dates are then used in a query on the database. All works well on my computer,(i.e. all the right files are downloaded) but when I put my site on the web server strange things happen...

On the server.. if the day of the month is between 1 and 12 the server assumes that the date is a us date mm/dd/yy. If the day is above 12 then the web server gets it right i.e. a uk date is assumed!

Thus, it seems that the server defaults to US date unless it obviously can't be then it assumes UK format as a secondary choice.

What can I do?? I feel stuck because the code on my local host computer is working perfectly by correctly using UK date format all the time and the server is messing things up!!

Any help would be much appreciated!

Can you try converting the dates to an ODBC date/time value (with createODBCDate()) when you run the query? I believe that ODBC date/times are independent of locale formatting (US vs. Europe, etc.).