Date Oddity

[lauriebizz]

Hi there, I'm running Crystal 9.0 / SQL

I've run into an oddity, when exporting a report into excel, the date is returning ()10/6/2006 for a few lines. When I select the cell in excel, it looks normal as well. It looks just fine in Crystal and I’ve not had this happen before that I am aware of. Any idea what this might be?

Thanks -
Laurie

 

[satinsilhouette]

If CR is handling it fine, I am not sure what the concern is here?

Thanks so much!
satinsilhouette

 

[lauriebizz]

When slicing and dicing the data in a pivot table, I can not group by date.
Thanks!
Laurie