MOM 6 -R&R - Excel question

[simulacra]

We just upgraded to MOM 6 and R&R v12.5. I have tweaked all of our old R&R reports so they work well on R&R, but for those that I need to export to Excel from R&R I am having problems. The dates are looking fine on R&R but when I look at it in Excel, the date doesn^t translate; it comes out as three symbol characters. Do I need to create a calculated field that converts the date/time fields back into date fields? Thanks.

[kfleming]

Create a calc that converts the date to a character string and then export that calc field instead of the date field.____Kathleen__R&R Support