[AccessD] Date Problem Again

DWUTKA at marlow.com DWUTKA at marlow.com
Tue Apr 18 16:29:10 CDT 2006


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

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



More information about the AccessD mailing list