[AccessD] Date Format Again

Again, why Rocky?  A date is a date.  If you are 'encoding' it, you know the
format you have encoded it as.  So if you are encoding mm/dd/yy, and you
want to compare it to the local date, then just use DateSerial.

It doesn't matter what region you are in, you are setting the encoding to
the format that you want, right?

Drew



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, May 20, 2004 10:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Date Format Again


Jim:

One problem - I'm not using a regular date.  I'm assembling the date which
is encoded in a key.  So to build the date, I need to know the format to
construct it in - mm/dd/yy or dd/mm/yy.

I then compare it to the system date to see if the license has expired.

Rocky

----- Original Message ----- 
From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, May 19, 2004 6:04 PM
Subject: RE: [AccessD] Date Format Again


> Hi Rocky:
>
> Why do you not use this piece of code to check the date. It does not
matter
> what is the format of the date, in which region because a Day is still a
> day, a Month is still a month and so on... The following code will
translate
> any date.
>
> if format(DateSerial(Year(Date), Month(Date), Day(Date)),"yyyymmdd") >
> MyCutoffDate then...
>
> Just pick your required result format.
>
> HTH
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Wednesday, May 19, 2004 8: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 yyyy-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.
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

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