Page Comparison

This article provides a workaround for displaying the date fields in the DDdd-MM-YYYY yyyy format.

Instructions

To display the date field in a particular format, such as DDdd-MM-YYYYyyyy, create a calculated field and use that in the report.

1. Create a calculated field to format the due date in DDdd-MM-YYYY yyyy format. For example, here we are creating the calculated field named Due Date(dd-mmMM-yyyy).

   • This field presents the date format as 01-12-2024.

   • The expression is IF ELSE(NOT(IS NULL(Due date)), CONCAT(FORMAT DATE(Due date, 'dd [day of month]'), '-', FORMAT DATE(Due date, 'MM-yyyy')), ' ')

...

2. Add the calculated field to the report.

   • Create a List report and add the field as shown.

   • Select the calculated field "Due Date(dd-mmMM-yyyy)".

   • Run and Save the report.

   • Outcome: The report displays the sum of the number of issues along with this due date.

...