I have data in text field as "yyyymmdd" I simply need to convert this to "mm/dd/yyyy".
I have looked at Access Help, and through these forums. I can't seem to make anything work. I'm sure it is something simple that I'm missing.
Can someone please enlighten me.