[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 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gina Hoopes
Sent: Thursday, December 22, 2005 11:57 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Text to Date conversion

Merry Christmas, everyone.

I feel like I'm losing my marbles because I can't figure out what's
going 
wrong in my query. I've got a table that I imported from Excel with the 
dates in European format and stored as text. I'm trying to convert the
text 
to a U.S. date with the following function. AwardDate in this example = 
"05102005"

Format(DateSerial(Mid([awarddate],3,2),Left([awarddate],2),Right([awardd
ate],4)),"mm/dd/yyyy")

The result comes out not as 10/05/2005 but as 10/26/2015.

I put the Format function in to try and fix it but it's the same with or

without Format. There must be something I'm just not seeing. Can someone

give me a boost here?

Thanks!!
Gina


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


This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]