date format calender object

[johnv20]

Hi,
I'm in the process of moving a web site from a windows 2000 server to a windows 2003 box

When running the web site under VS2005 debug mode the date format being passed to a database is correct, i.e. 14th Dec is passed as 14/12/2006

However when I try & run the web site normally via IIS the date format is getting changed so that 14th Dec becomes 12/14/2006

Does anyone how I can force the calender object to send data in a DD/MM/YYYY format ?

 

[jbenson001]

You will have to change the dateformat of the machine that IIS is running on. (Regional Settings)

 

[johnv20]

Tried that but to no avail.

I've worked around this by changing the database code to utilise datetime format of 101 which will resolve