Idea ID: 1792017

Date and time format when exported to csv

Status : Delivered
over 2 years ago

Hi Team ,

Description : When we pull the reports in CSV format the date& time field will be exported in (EPOCH TIME –Unix time)  Attached is the screenshot on how data looks in SMAX and once exported to CSV.

Benefits / Value : This issue is seen only when exporting the file in CSV format . This is causes lot of manual effort . One exported we need to have formulas to convert them back to date and time format 

Design details:  There are 2 options either we need to have Export to Excel option in reports as formatting of dates is available if you use the "Export to XLS" from the grid view but not from the reports or when the report is extracted in csv it should come in proper format as date and time instead of EPOCH