Formula exported from Crystal to Excel not returning Date

[TerriO]

I have a report that is using a simple formula if the criteria is met from one table (doc name and status) then return the date. The information comes back perfectly in Crystal but when I try to export it to an excel sheet regardless of the excel version (max version is 8.0 extended) I am getting a long number for all of the fields whether there should be a date or not. I have formatted the date and still cannot come up with a solution for this problem. Please help! Terri Mimbs

 

[dgillz]

This belongs in the crystal reports formula forum, not the certifications forum. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[sravula]

Format the Crystal date field as '3/1/99' instead of '03/01/1999' or anything else and then export it to excel. You'll get the correct date-formatted field in excel that appears as '3/1/1999'.