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