Hello,
I have a strange situation with a script I wrote. I have a script that uses dates extensively, user can select a date from 3 drop down menus (dd/mm/yyyy), save it to the database, then the entry is queried for specific date and then the entry is displayed. (In a nutshell
Now when I run the script on a server with UK locale the dates get assembled correctly, saved in the database correctly, when queried for a specific date it works correctly, but as soon as I fill a recordset the dates switch from dd/mm/yyyy to mm/dd/yyyy
and only if the day value is less then 10, so for example May 3rd would end up being displayed and read by ASP as March 5th, even though the database has the date corectly. Any ideas why it would happen and how I can fix it ? LCID is set to UK.
I have a strange situation with a script I wrote. I have a script that uses dates extensively, user can select a date from 3 drop down menus (dd/mm/yyyy), save it to the database, then the entry is queried for specific date and then the entry is displayed. (In a nutshell
Now when I run the script on a server with UK locale the dates get assembled correctly, saved in the database correctly, when queried for a specific date it works correctly, but as soon as I fill a recordset the dates switch from dd/mm/yyyy to mm/dd/yyyy
and only if the day value is less then 10, so for example May 3rd would end up being displayed and read by ASP as March 5th, even though the database has the date corectly. Any ideas why it would happen and how I can fix it ? LCID is set to UK.