[AccessD] Date issues in Access

Gustav Brock gustav at cactus.dk
Mon Sep 22 06:30:00 CDT 2003


Hi Stuart

No ... mm is the month numeric value formatted with a leading zero for
months with one digit.

/gustav


> Yeah but isn't mm also localised?  If so how is

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

> Any different?

> As I said, I'm curious :)

> Stuart

>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Gustav Brock
>> Sent: Monday, 22 September, 2003 6:25 PM
>> 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