Drew Wutka
DWUTKA at marlow.com
Sun Feb 2 04:11:00 CST 2003
Oh the joys of formatting dates! <VBG> Drew -----Original Message----- From: Stuart McLachlan To: Drew Wutka; accessd at databaseadvisors.com Sent: 2/2/03 2:50 AM Subject: RE: [AccessD] Date Format Mea Culpa, I was thinking in terms of my suggested solution which was designed to convert all 20XXs to 19XXs. > Back at ya! The issue is still moot, since it is past 2000, my code doesn't > do anything unless the date entered is after today's date. > > <VBG> > > Drew > > <snip> > > > > The only issue you may run into, is a leap year, but since your > 'moving' the > > date by a century, that shouldn't be much of an issue. > > > > Au contraire :-) > This is the only time in 400 years that it IS an issue. > 2000 is a leap year, 1900 is not. > > > > -- > Lexacorp Ltd > http://www.lexacorp.com.pg > Information Technology Consultancy, Software Development,System Support. > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.