Date problem driving me in Mad

[spgreen]

All,
i Have a problem when updating a access database with information from my asp app, I know you have solved this problem before but i cant get anything to work. when testing on my local PC the app works fine and the date is correctly entered onto the test db, but when i go to run the system on the web-server it reverses the date. to mm/dd/yyyy. i looked at the actual sql string on both the test server and the live system the test system has the date in the correct format but the live server changes the date around so it is enter onto the db incorrectly. I've checked the local/internal settings on the server and the are all set correctly just as they are in my test setup.

please please help

Simon

 

[DreXor]

search the forum for "date format"

guessing you probably want along the same lines of format UK date in the search results


DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!

 

[spgreen]

this is not the problem, it's when add the information to a new record on the database, the sql string looks like DD/mm/yyy, but when i view the record on the db the record is formatted mm/dd/yyyy. the date is correctly formated on screen and the sql string it only when the record gets added to the database

 

[Creto]

Is it possible that the time/date settings on the server are set to format it in that fashion?

 

[spgreen]

I've checked this out but the settings are all correct. the regional settings are set the same as my local PC. any body else, just one thing to add. i changed the db structure this morning so the time and date the record added is added is entered by the database and the dates get entered in the correct format.

 

[snowboardr]

It is because if you have a date field the database will change your date to fit the db format of the date, and will output it like a normal date... i know its wierd but thats how they do it....

Jason

www.sitesd.com
ASP WEB DEVELOPMENT

 

[beaniebear]

I'm having the exact same problem. Just wondered if you managed to sort out why this is occuring?