Gustav Brock
gustav at cactus.dk
Mon Sep 22 06:30:00 CDT 2003
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.