[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