[AccessD] Date issues in Access

I haven't been following this thread too closely, but it seems reasonable that any given instance of a database would use only one of the international formats. In which case, why not define a bunch of date formats as constants, and then during the setup procedure present the list of date formats and either get the user to select one, or alternatively base it on the country in which the user is based? Either way, then the calls for Format() would use the constant.

Just a thought.

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]
Sent: Monday, September 22, 2003 4:48 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003