[AccessD] Text to Date conversion

Thank you, Gustav!

Gina

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
Sent: Thursday, December 22, 2005 1:34 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Text to Date conversion

Hi Gina

As Mark puts, just split the string but remember to wrap it in #..# to 
indicate a date value:

  SELECT
    *,
    "#" & Mid([awarddate],3,2) & "/" & Left([awarddate],2) & "/" & 
Right([awarddate],4) & "#" AS AwDate
  FROM
    tblYourTable;

/gustav