converting strings to dates in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You need to parse it first.
CDate(Left([YourTextField],2) & "/" & Right(Left([YourTextField],4),2) & "/"
& Right([YourTextField],2))
 
Back
Top