Converting Text to Date

[Gman1950]

I have a test field with a date e.g. 090303 and I want to convert it to a Date like 09/03/03. Can anyone tell me how to ??

Thanks
Jeff

 

[DaveSwanton77]

Jeff,
If the date is always six digits use this query.

SELECT Left([Date],2) & "/" & Mid([Date],3,2) & "/" & Right([Date],2) AS NewDate
FROM Table1;

Regards Dave

Table1 is the name of your table and Date is the name of the field with NewDate being the new name of the field for output