IBM JRS change date format changes with export to spreadsheet with live data option
![]() 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
|
One answer
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Jun 23 '22, 2:56 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Jun 23 '22, 3:00 a.m. I'd say the date formats you are showing are obviously using the clients locale. If you want one dedicated locale, then try to not use the setting "Date(date/time shown as a date in the clients locale)". Pick a locale or let it use the server locale or whatever other option there is? Comments Hello Ralph,
Thank you for the quick response.
We have string and url option apart from the all other client's locale.
No other option is there for server locale or any locale option
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.