Arthur Fuller
artful at rogers.com
Wed Jul 21 11:53:24 CDT 2004
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