date reverse error

I

imfsub12

yes i have a .aspx aplication running on my localhost, my dev server and my
live SERVER..

When i add a entry to my DB (access) it picks the date or i can select it
from a calander. So what is happeing is that i select say 2/1/2005 (m/d/y)
and then i save the entry and then it comes up with 1/2/2005 (m/d/y) when it
displays it on the scren. but if i enter 2/13/2005 it enters the date
perfict...

But this is only happeing on my LIVE SERVER..... and my programers don't
know what is wrong and my webserver ppl don't know what is wrong and i'm in
the middle trying to solve this problem.. i need help..

Also to my friend said they saw this error long ago in excell..

[email protected]
 
D

david epsom dot com dot au

When displaying the date always use the format dd-mmm-yyyy

Unless you need to use the date in an SQL statement: in which
case international formats for the month string will cause
failure.

(david)
 
I

imfsub12

see the thing is that i'm not the programmer on this. i'm just the client..
and
THe CODE works on a DEV server and my LOCALHOST then when i pub it to my
LIVE server differn't from the DEV. The dates get reversed...

RIck
 
J

John Vinson

see the thing is that i'm not the programmer on this. i'm just the client..
and
THe CODE works on a DEV server and my LOCALHOST then when i pub it to my
LIVE server differn't from the DEV. The dates get reversed...
Click to expand...

Check the date/time settings in Start... Control Panel... Regional.
They are probably different on the two machines. These date/time
formats will be used as the default; you can override them by
explicitly setting the date format in Access.

John W. Vinson[MVP]
 
Top