date backwards? 1

[ProgramError]

Would anyone know why, if I type this in the immediate window
debug.? #25/06/08#
i get this returned ...
08/06/25
instead of 25/06/08
?


Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Remou]

Because the immediate window looks for mm-dd-yyyy but returns dd-mm-yyyy.

?day(#01/07/2008#)
Ans: 7

 

[PHV]

Always use non ambiguous notations:
? #2008-06-25#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Golom]

Looks like you have your short date format set to yy/mm/dd in regional settings.