Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Pallavi Deore
(38●1●50) 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

0 votes

1 answer
1,154 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) 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?

0 votes

Comments
Pallavi Deore
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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,497
× 6,124
× 1,327
× 360
× 26

Question asked: Jun 23 '22, 2:50 a.m.

Question was seen: 1,154 times

Last updated: Jun 23 '22, 5:11 a.m.

Related questions
Confirmation Cancel Confirm