[AccessD] Date issues in Access

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.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2560 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030922/f1b91ff6/attachment-0001.bin>