It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,786
×11,923

question asked: Apr 11 '17, 11:05 a.m.
question was seen: 1,281 times
last updated: Apr 11 '17, 9:45 p.m.

Related questions

FAQ - How this Forum works

How to change the Date format?

0
Prashanth Danda (11●2) | asked 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

Comments
Kevin Ramer commented Apr 11 '17, 11:45 a.m. | edited 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 commented 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

One answer

Most liked answers|Newest answers|Oldest answers ↑

1
permanent link
Lily Wang (4.9k●7●14) | answered 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.

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.