It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×7,387
×6,077
×1,215
×355
×24

question asked: Jun 23 '22, 2:50 a.m.
question was seen: 821 times
last updated: Jun 23 '22, 5:11 a.m.

Related questions

FAQ - How this Forum works

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

0
Pallavi Deore (38●1●41) | asked Jun 23 '22, 2:50 a.m.

 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.1k●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
Pallavi Deore commented Jun 23 '22, 5:11 a.m.

 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

Register or to post 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.