[AccessD] Text to Date conversion

I was worried that by using what you suggested that I'd just end up with 
another string. I'll give that a try.

Thanks!
Gina

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

Gina -
Why use the DateSerial function at all?  You should be fine using:
Mid([awarddate],3,2) & "/" & Left([awarddate],2) & "/" & 
Right([awarddate],4).


Mark Boyd