[AccessD] Date formats

Gustav Brock gustav at cactus.dk
Sat Mar 6 03:06:31 CST 2004


Hi Ralf

> when I have this date #06/03/2004# and run the Month function I get "Month(#06/03/2004#) = 6". Thats correct for the United States!
> But as I am in Bolivia I need "Month(#06/03/2004#) = 3".
> I logged on to "Regional Settings" in the Control Panel and changed in the leftmost tab the two dropdown-boxes to "Bolivia". But it didn't help at all.
> Can someone help me in achieving "Month(#06/03/2004#) = 3" ?

Well, Month(#06/03/2004#) is 6 if you write this in code.
However, if it is typed in the GUI of, say, the query designer, it is
3 because Access tries to interpret your local settings. But, if you
switch to the SQL code view, it is written #03/06/2004#.

You will have to adopt to this.

/gustav




More information about the AccessD mailing list