Symptom
Some date/time fields, when exported to Excel, are exported with text formatting
Cause
You may be exporting a "Group Name Field", which by design, are text fields.
Resolution
In the report design layout, replace the "Group Name Field" with its original data table field.
Keywords
sorting, sort, string , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2