saves wrong dateformat in Access

Haroldd · July 10th, 2003, 06:50 AM

i save the mutationdate of a page in access in the format dd-mm-yyyy...this went good but all of a sudden in the database the format is mm-dd-yyyy (i now have both dateformats in my database which really sucks :()

when i response.write my sql statement i see the correct dateformat (so in this example 10-7-2003=10 july 2003) but in the database it saves 7-10-2003

below you see my sql statement

Quote:

quote:
update page set content = 'test', date = '10-7-2003', levelid = 2, author = 'Harold', levelnaam = 'test', deelprocesid = 0, previous = 119, next = 0 where contentId = 245

it really drives me nuts...so i would be glad if somebody could help :)

Harold

Steven · July 12th, 2003, 09:52 AM

One easy way to do it is change your computer's regional settings to somewhere that uses dd-mm-yyyy (eg Australia) if you want it that way.

Another way is to change it using DatePart to extract the parts and put them back.
eg: DatePart('m',date) & '/' & DatePart('d',date) & '/' & DatePart('yyyy',date)

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends

KenSchaefer · July 23rd, 2003, 03:30 AM

www.adopenstatic.com/faq/DatesWithAccess.asp

www.adopenstatic.com/faq/systemDateFormat.asp

Cheers
Ken

www.adOpenStatic.com