[AccessD] Date Format Again

Hi Rocky

If you are encoding the date as a date string, you need to decode that
and parse it to build the date value; that may involve a little
puzzling with Mid() to get strYear, strMonth and strDay which you can
convert to Longs and feed to DateSerial().

/gustav


> If they use the US date format, then what do you mean by their having
> their machines set to yyy-mm-dd?   Cdate(Date) will return a  date in
> the system format.   

> Charlotte Foust

> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
> Sent: Wednesday, May 19, 2004 7:06 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Date Format Again


> Dear List:

> I thought I had the date format problem solved but in Taiwan they use
> the US format but they've got their machines set to yyy-mm-dd.  

> The problem is that I have a license expiration date encrypted in a key
> and so the routine that decodes the key yields (among other things) the
> expiration date which I compare to the system date.

> So I guess I'm going to have to use an API to get the regional setting
> for short date format?  I've been mucking around in the Knowledgebase
> but can't seem to find what I want.

> Does anyone know the format for retrieving this item?  

> I guess I will have to use a Select Case on the short date format to do
> the decryption to yield a short date in the local format.  And just add
> cases as I find more short date formats.