[AccessD] Date issues in Access

The idea is for the format to adjust itself based on the specified
formats in the regional settings of the machine, I believe.

Charlotte Foust

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Monday, September 22, 2003 2:24 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com