converting strings to dates in MS Access

A

Access refresher

I am trying to convert a string such as 071505 in a query in Access to a
date. I used all of the date built in functions in Access 2003 but none seem
to give me 7/15/05 or anything accurate. Any ideas?
 
K

KARL DEWEY

You need to parse it first.
CDate(Left([YourTextField],2) & "/" & Right(Left([YourTextField],4),2) & "/"
& Right([YourTextField],2))
 
Top