Full Version: Convert Text Date To Long Date Format
UtterAccess Forums > Microsoft® Access > Access Date + Time
Hi There-
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?
This is a case where you'll have to parse out the elements of the string before you can convert it to a date.
ateSerial(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.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.