Gustav Brock
gustav at cactus.dk
Tue May 4 12:02:12 CDT 2004
Hi Erwin > There is another oddity I Access when using dates... > I believe its a bug since Access 2K. > Try this (you all know that u can simulate a american date with #[Date]# > ? cdate(#1/12/2004#)-1 this results in 11/01/2004 beeing 1 january 2004 > ? cdate(#31/12/2004#)-1 this results in 30/12/2004 beeing 30 december > 2004 > ? cdate(#12/31/2004#)-1 this also results in 30/12/2004 beeing 30 > december 2004 > Bizare he? > Never trust Access with dates..... > I supose this bug is only in the international versions... It's not a bug, it's CDate() being intelligent. First attempt is to check if the expression conforms to a US date. If that fails, it tries an international (ISO) format or your local settings, then another etc. - that's why it also understands #2004/01/12#. /gustav