Full Version: Convert Text Date To Long Date Format
UtterAccess Discussion Forums > Microsoft® Access > Access Date + Time
cronk005
Hi There-

I tried a couple of examples in the forum but couldn't figure it out.

I have a medical imaging device that exports date in text format as YYYYMMDD and I need to convert it into the Long Date to give me day of the week, etc.

I tried using CDate(), no luck.

My field is Exam Date .. Do we have any thoughts on things I can try?

Regards,

Daniel
GroverParkGeorge
This is a case where you'll have to parse out the elements of the string before you can convert it to a date.

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

Then, you can display it as the long date format you need.
cronk005
Awesome. That's exactly what I needed. Thanks so much for your response.

Regards,

Daniel
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.