Date problem

[elibb]

hi.. i know ive asked this question manu times, but i still have the same problem, i really hope someone can help me.
im making a program in vb6 with a database in access, and i want to make a query according to the date.

if i put:
15/12/2001
it takes it as december 15th which is what i want.

but if i put
05/12/2001
it takes it may 12th.

ive tried this

format(strDate, "dd/MMM/yyy&quot, because on the database i have that format : 05-Dec-2001
but i get the same results... and its making me crazy because my queries turn out all wrong

thank you very much

Eli
i hope somebody can help me

 

[oneshadow]

try to using "MM/DD/YYYY" format coz as far as i know it is MS Access default.

 

[chiph]

Do a google search for ISO-8601, which is the international standard for representing dates and times. It's basically "yyyy-mm-dd hh:hh:ss".

I have had no problems using this format with VB's date variable type, SQL Server, and ASP/Javascript.

Chip H.