[AccessD] Date Problem Again

On 18 Apr 2006 at 14:22, Rocky Smolin - Beach Access S wrote:

> 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?
> 

Use DateSerial() to build the date. It is always (y,m,d) regardless of 
regional settings.




-- 
Stuart