Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting a Date into MS Access

Status
Not open for further replies.

mcode12

Programmer
Aug 8, 2007
25
GB
I've just noticed that when I insert a date and time into MS Access the date is 08/09/2007 when it should be 09/08/2007

This is strange as it's on a UK server and when i do response.write now() i get 09/08/2007 which is correct.

Anyone got any ideas why this has happened?

 
Hi Dave it work perfectly when I place Session.LCID = 2057 at the top of the page.

I'm just thinking that why should I need to do this if the server is hosted in the uk? Have the hosts missed something?
What's going on? and why when I do response.write Now() is the date in the right format?

thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top