It's all about the answers!

Ask a question

Can you change the date format of reports

Jason Wilson (31925) | 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
Please review this and see if it answers your question.

Your answer

Register or to post your answer.