Date toggle on update

[Microbe]

In Australia our date format is dd/mm/yy as against the US format of mm/dd/yy.

As far as I can tell, my whole machine is set for dd/mm/yy.

I have an Update page that has a date in a text box so it can be changed.

If I have a date, say 6/1/00 in the field and look in the database it shows 6-Jan-00 if I have it set on medium date. Perfect.

If I then click update without making any changes, the field updates to 1/6/00 and the db says 1-Jun-00

Obviously there is a conflict somewhere. I can't see it in Access, IIS or on my computer.

Any ideas?

Thanks in advance

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[mrichards]

Did you check the date format of the server? Ihave had problems with that before.

Mark