DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Dec 22 11:22:35 CST 2005
Glad I could help.... Drew -----Original Message----- From: Gina Hoopes [mailto:hoopesg at hotmail.com] Sent: Thursday, December 22, 2005 11:15 AM To: AccessD at databaseadvisors.com Subject: Re: [AccessD] Text to Date conversion Well that explains it. Ho Ho Ho!! Gina -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, December 22, 2005 11:02 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Text to Date conversion DateSerial goes Year, Month, Day. So with 05102005 you would want: DateSerial(val(right(awarddate,4)),val(left(awarddate,2)),val(mid(awarddate, 3,2))) Drew -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com