[AccessD] Date issues in Access

Stuart Sanders stuart at pacific.net.hk
Mon Sep 22 05:38:49 CDT 2003


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
>




More information about the AccessD mailing list