It's all about the answers!

Ask a question

Can you change the date format of reports


Jason Wilson (31719) | asked Sep 05 '19, 4:32 a.m.
Hi all,

I am new to using Report Builder, and I am wondering if anyone is able to assist me please.

I have a report that I created and part of the report is to display the date a certain action occurred. Now due to customers being located in different geographical areas I am trying to fix the format of the date so that there is no ambiguity.

Currently the report displays the date as '8/29/19 12:00 AM' (mmddyy), however so that it is consistent with everything else we do I would like to be able to change this to '29 Aug 2019 12:00 AM' (DDMmmYYYY).

Can anyone help and advise if this is possible please.

One answer



permanent link
Gerard Cregan (613) | answered Sep 05 '19, 11:43 a.m.

 Hello Jason,


This issue is discussed in the following TechNote:
Dates and Times in Report Builder for Jazz Reporting Service are different to those in Configuration Lifecycle Management applications
https://www.ibm.com/support/pages/dates-and-times-report-builder-jazz-reporting-service-are-different-those-configuration-lifecycle-management-applications
Please review this and see if it answers your question.

Your answer


Register or to post your answer.