Need to use an update query on date string field

[clawschieff]

Hi all,

I have fields in MS Access 2010 for DOB, DOD, and DOI (Date of Internment) that are string fields. All of the records in this field are in the form of YYYYMMDD. I want to write an update query to change the format to MM/DD/YYYY (changing the order and adding the forward slash). I can do it in excel, but I don't want to export and then import back into Access, and I'd like to learn how to do everything I know how to do in excel in Access.



Thanks!

[June7]

Try:

DateSerial(Left([DOB],4), Mid([DOB], 5, 2), Right([DOB], 2))

or

Mid([DOB], 5, 2) & "/" & Right([DOB], 2)) & "/" & Left([DOB],4)

[clawschieff]

Yep that worked,
Thank you