[AccessD] Date Problem Again

retrieve information from the computer's locale that created the string to 
determine short date format of dates

http://www.mvps.org/access/api/api0017.htm


>From: Rocky Smolin - Beach Access Software <bchacc at san.rr.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: [AccessD] Date Problem Again
>Date: Tue, 18 Apr 2006 14:22:20 -0700
>
>Dear List:
>
>I have an expiration date encoded in a key.  It has the month and year
>of expiration which I extract into two two-character strings mm and yy.
>For the U.S. no problem - I just assemble the date "mm/dd/yy" (where dd
>is always '01') and compare it to the computer's calendar.  But if the
>program is being used outside the U.S. the date has to be assembled
>"dd/mm/yy".  Is there an easy way to find out which format to use or
>another way to get around the mmdd/ddmm problem altogether?
>
>MTIA
>
>Rocky
>
>--
>Rocky Smolin
>Beach Access Software
>858-259-4334
>www.e-z-mrp.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com