[AccessD] Date Problem Again

Drew and Stuart:

AHA!  DateSerial.  Is there no end of stuff to learn that Access can do?

Thank you and thank you.

Rocky


DWUTKA at marlow.com wrote:
> Use DateSerial to assemble the date.  the placement of it's arguments do not
> change with date formats.
>
> Drew
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Tuesday, April 18, 2006 4:22 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Date Problem Again
>
>
> 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