[AccessD] Date formats

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.






More information about the AccessD mailing list