It's all about the answers!

Ask a question

[closed] IBM JRS change date format changes with export to spreadsheet with live data option

Pallavi Deore (3819) | asked Jun 23 '22, 2:51 a.m.
closed Jun 23 '22, 2:53 a.m. by Ralph Schoon (62.0k33643)

 Hello All,

I have created historical report in jrs and used change date with option "Date(date/time shown as a date in the clients locale)".
When I export that report to excel with download spreadsheet with live data.
Live Excel sheet has change date in different formats.. Sometime it shows "","dd-mm-yyyy","dd/mm/yyyy","mm-dd-yyyy". Change date format is not fixed while exporting to spreadsheet with live data option.
We need stable format for change date, please suggest.

Thanks in advance
Pallavi Deore

The question has been closed for the following reason: "Duplicate Question" by rschoon Jun 23 '22, 2:53 a.m.