Date Swap using an access db

[Erikson]

Hi,

When i use the following code;
rsgevallen.Open
("select * from [numbers] where Date = #" & Datechoose & "#&quot, cnDB, adOpenStatic, adLockOptimistic

and the date in datechoose is 16-10-02 it find's the record 16 october no problem.
when the date in datechoose is 3-10-02 it find's 10 march ??

the date is a short notation d-mm-yy and i am acccessing an access database

does anyone has any idea's ?

Thanks

Erik

 

[Shlomo47]

try:
rsa.Open ("SELECT * FROM [numbers] " & _
"WHERE Date= " & "#" & Format(Datechoose, "mm,dd,yy&quot & "#&quot

For me it worked with similar problem

Shlomo

 

[petermeachem]

Still won't always work. Use dd mmm yyyy instead Peter Meachem
peter @ accuflight.com

 

[Erikson]

Thanks for the input,

It works fine now

Erik