[AccessD] International date format problem

Arthur Fuller fuller.artful at gmail.com
Thu Aug 2 06:38:05 CDT 2012


Pursuant to this thread, I decided to try a few things:

? DateValue("2102-02-02")
2/2/2102
? DateValue("Jun-21-12")
6/21/2012
? DateValue("21-Jun-12")
6/21/2012
? DateValue("2012/06/02")
6/2/2012
? DateValue("21/Jun/12")
6/21/2012
? DateValue("2012.06.02")
--> Type mismatch

These are the only date formats I could think of at the moment. Conclusion:
DateValue() works almost all the time.
Arthur

On Thu, Aug 2, 2012 at 3:16 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Rocky
>
> Welcome to reality. But where have you been all these years? This is a
> classic that has been up over and over again.
>
> /gustav
>
>
>


More information about the AccessD mailing list