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

How to change the Date format?

Questions
Tags
Users
Badges
Prashanth Danda
(11●2) Apr 11 '17, 11:05 a.m.

I run a query in Work Items.


The result displays Date in Text format
Apr 5, 2017 12:05 PM

I want the Date to be displayed in Excel format
05/04/2017 12:05

How to update Rational so that the Query result displays Date in Excel format?

Thanks

0 votes

Comments
Kevin Ramer
Apr 11 '17, 11:45 a.m.
IMO: The former suffers no ambiguity while the latter begs: Is it May 4, or Apr 5, noon or midnight....

Prashanth Danda
Apr 11 '17, 11:55 a.m.
Hi Kevin, I understand the ambiguity that you have mentioned.  For the Work Items calculation that I am doing, I want to see Date in Excel Format i.e. dd/mm/yyyy hh:mm Is it possible to configure the Date attribute in Rational so that it displays Date in the above mentioned Excel Format in Query result? Thanks

1 answer
4,270 views
0 votes

One answer

Permanent link
Lily Wang
(4.9k●7●14) Apr 11 '17, 9:45 p.m.

The date format shown in the query result is based on the web client's locale setting. To change the format, you need to modify the Language setting of your web browser.

1 vote

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
× 12,144

Question asked: Apr 11 '17, 11:05 a.m.

Question was seen: 4,270 times

Last updated: Apr 11 '17, 9:45 p.m.

Confirmation Cancel Confirm