Versions Compared

Old Version 5

changes.mady.by.user Nisha Shantilal

Saved on

compared with

New Version Current

changes.mady.by.user Kinnera

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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')), ' ')

...