[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

Gina Hoopes <hoopesg at hotmail.com> wrote:
  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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com