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