[AccessD] Text to Date conversion

Another great solution. Thanks!

Gina

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
Sent: Thursday, December 22, 2005 11:56 AM
To: Access Developers discussion and problem solving; 
AccessD at databaseadvisors.com
Subject: Re: [AccessD] Text to Date conversion

If you used the method below, it would be a string.  You could do 
CDate(Mid([awarddate],3,2) & "/" & Left([awarddate],2) & "/" &
Right([awarddate],4)) to get the date.

  Thanks,
Jeremy