This content has been marked as final. Show 4 replies
Just double click that column in physical layer and change the datatype.
Mark as correct if it is helpful
The date format in the physical is already a "DATE". Its still displaying text like filed when exported to excel.
Edited by: Prash11 on Feb 18, 2013 10:07 PM
Try to apply cast function.
Open your report--> Go-->FX-->Apply below cast function.
Cast(Your date column as date)
Save it and try to download .
If still issue occured please update you post.
Hope this help's
Hi,1 person found this helpful
provide the custom format in the data format-->override default format with a custom format which is required
and also change the format column properties-->style-->custom CSS style options-->give the MSO format.
It will export into the excel as expected.
mark if helpful/correct..