[AccessD] Date issues in Access

Gustav Brock gustav at cactus.dk
Mon Sep 22 11:40:56 CDT 2003


Hi Charlotte

I may have misunderstood the question of Stuart.


In code nothing is localized.
As you know, you have to use US syntax.

In the SQL GUI, _displayed_ code is localized:

   Format(Now(),"dd/mmm/yyyy hh:nn:ss") AS Dat

displays:

   Dat: Format(Now();"dd-mmm-åååå tt:nn:ss")

and would return, in October, this localized result:

   22-oktober-2003 18:35:38


I had the result in mind.

/gustav


> What do you mean by localized in this context, Gustav?  Using "mmmm" as
> a format will result in the full month name in whatever language, and
> using "mmm" will result in the month abbreviation.  Of course, the
> abbreviation may not be 3 characters in every language, but "mmm" adapts
> to that and displays the longer abbreviation.

> Charlotte Foust

> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk] 
> Sent: Monday, September 22, 2003 2:25 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Date issues in Access


> Hi Stuart

> Nope, mmm is localized.

> /gustav



>> Just curious...

>> Does this work for internation systems?

>>   StrDateSQL = Format(dat, "\#dd\/mmm\/yyyy hh\:nn\:ss AM/PM\#")

>> Note mmm, not mm.



More information about the AccessD mailing list