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

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.

Awesome. That's exactly what I needed. Thanks so much for your response.

Regards,

Daniel