[AccessD] Date issues in Access

Hi Stuart

The SQL code is not localized. But those parts of the code which are
displayed in the SQL GUI designer are. That did cause some confusion
for the interpreters of the help file because they couldn't keep track
of where to localize date formatting strings and where not!

/gustav


> Yes, but my understanding was that the localised string for months isn't the
> same for all versions.

> Ie not all versions use "mm" for month, "dd" for day, etc.

> If that is the case (and I'm remembering from access 97 days, so I might well be
> wrong), then "\#mm\/dd\/yyyy hh\:nn\:ss AM/PM\#" wouldn't work in all regions,
> because you'd have to substitute the various characters for their local
> equivalents.

> 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 7:30 PM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Date issues in Access
>> 
>> 
>> 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.