inserting dates into access problem

[stinkybee]

I am trying to insert dates into my access database in the format dd/mm/yyyy.

However, it appears to swap the day and month around when inserting the values to mm/dd/yyyy. For example, if I enter 01/03/2006 it will insert 03/01/2006 into the database.

I have set the locale to UK in my asp script and my computer and server are both set for UK date formats. All other access databases on my server work with the correct format.

I can not work out what the problem is, does anyone have a solution for this?

 

[therayster]

I believe you can force the desired format via the VBScript format function:
Format(Date, "MM/DD/YYYY")

Not sure if there's a simpler way...

 

[ChrisHirst]

the function is FormatDateTime(date,formatstyle) and formatstyle is a numeric value (or constant)

http://www.w3schools.com/vbscript/func_formatdatetime.asp

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[tsdragon]

Yup, ChrisHirst is correct. That's one of the MANY annoying little difference between VB and VBScript that constantly trip me up.

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.