Inserting a Date into MS Access

[mcode12]

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?

 

[guitardave78]

Try submitting it #09/08/2007#

Also make sure that the server is looking at the right date format for the uk
At the top of the page add <%Session.LCID = 2057%>

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[mcode12]

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.

 

[guitardave78]

Ah the mysteries of the webby net!

To be honest I don't have a clue! I just learned early on to use the lcid!

http://msdn2.microsoft.com/en-us/library/ms525071.aspx

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk