[AccessD] Date formats

Thanks to Stuart and Gustav. Now my Date functions work as expected.

Saludos
Ralf
----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Friday, March 05, 2004 10:21 PM
Subject: Re: [AccessD] Date formats


> 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.
>
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>