Oct 3 2011, 09:09 AM
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?
Oct 3 2011, 09:12 AM
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.
Oct 3 2011, 10:13 AM
Awesome. That's exactly what I needed. Thanks so much for your response.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here