Stuart McLachlan
stuart at lexacorp.com.pg
Fri Mar 5 20:21:12 CST 2004
On 5 Mar 2004 at 21:42, Ralf Lister wrote:
> Hello,
>
> 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" ?
>
The "#"s make it an SQL formatted date which is always interpreted as mm/dd/yyyy
Try Month("06/03/2004") instead. That will respect your regional
settings.
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.