Convert string to date in Update Query 1

[LyndonOHRC]

I'm needing to populate a new field with the date string stored in a text field. Past developer buried a key date in a text string with other data.

The date data is in cloumns 2-9 for the filename field. The string format is "*YYYYMMDD*********" and is zero filled so this should work if I just knew what functions to use and how to use them....

Thanks in advance.

UPDATE raceday  
SET racedate = CDate(Mid(FileName6,2) &'/'& Mid(FileName,8,2) &'/'& Mid(FileName,2,4)) WHERE 1=1

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[PHV]

What about this ?
UPDATE raceday
SET racedate = DateSerial(Mid(FileName,2,4),Mid(FileName,6,2),Mid(FileName,8,2))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LyndonOHRC]

Perfect! Thank you very much.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey