How to create a Calculated field to display the date fields in DD-MM-YYYY format using Reports and Timesheets for Jira app

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

Instructions

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

1. Create a calculated field to format the due date in DD-MM-YYYY format. For example, here we are creating the calculated field named Due Date(dd-mm-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-mm-yyyy)".

   • Run and Save the report.

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