Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Wed Jul 21 12:18:22 CDT 2004
;) Be careful Arthur...you might introduce a programming bug for which there is no "catchy" name. We are all familiar with the millennium bug (every 1000 years), however your approach will only work through the year 9999. Unfortunately, the next catchy phrase in time scale terms will be the "Epoch bug" (for which there is no set timeframe, but is, at a minimum, 1 million years). Mark -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Wednesday, July 21, 2004 12:53 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date format problem Why not modulus the year with 100 and grab the modulo? Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester A Sent: Tuesday, July 20, 2004 8:07 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Date format problem That would work but I only want the last 2 digits of the year. It needs to be that way to load into another program. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7414 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Perry Harold Sent: Monday, July 19, 2004 5:29 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date format problem Try "yyyy" Perry Harold -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester A Sent: Monday, July 19, 2004 9:45 AM To: accessd at databaseadvisors.com Subject: [AccessD] Date format problem The following expression in a query returns 2004 Test:[Forms]![frm Select Date]![selected_year] The following expression returns 05 in a query Test:Format([Forms]![frm Select Date]![selected_year],"yy") I an confused as to what is happening here. Help please. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7414 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com