Date and time format when exported to csv

Date and time format when exported to csv

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

 

Regards

Praveen 

Tags (1)
3 Comments
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Accepted

Praveen,

As you note, Export to Excel already has the user friendly date format.  And the Export to Excel option is being added to Reports in the upcoming release.

Thanks,

Steve

Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Delivered

This idea has been implemented in product release SMAX 2019.05. Check out the release notes for details. Thanks to all of our contributors for helping us continue to improve our products!

Micro Focus Expert
Micro Focus Expert

Hi Steve, 

 

Thanks a lot for the update 🙂 

 

Regards 

Praveen 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.