a bug in ms access??

[yanzhou828_99]

Dear all,

I try to convert a string to date in ms access 2003, use the function
##.

? #25-2-2008# the result is 25-2-2008

? #2-3-2008# the result is 3-2-2008

is this a bug in the access or am i something wrong?


Thanks in advance for any help

Regards,

Yan Zhou

 

[Allen Browne]

Not a bug, but a trap

For an understanding of how Access understands the dates you enter, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html