This SHOULD be doable with some kind of query but I cannot figure how or where to enter it.
I created a table many years ago with dates as text in mm/dd/yyyy format. I want dates in yyyy-mm-dd format. I added a newdate column that's empty.
Should be something like:
replace all newdate with substr(olddate, 5,4) + "-" + substr(olddate,1,2) + "-" + substr(olddate, 3,2)
I could've done this in a minute in FoxPro (I am old). I've tried to figure it out in Access for like 15 years now!
It's just a hobby database (authors and quotations). Where would I enter this command in Access and what's the correct syntax?
Eternal gratitude for an answer that works...
Steve M.