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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.