[closed] IBM JRS change date format changes with export to spreadsheet with live data option
Pallavi Deore (38●1●50)
| asked Jun 23 '22, 2:51 a.m.
closed Jun 23 '22, 2:53 a.m. by Ralph Schoon (63.5k●3●36●46) 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","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
|