Skip to Content

Configuring the display of the "Date / Time" attribute

  • Origin: Calculated attribute

In order to customize the display of the date in a certain format (in this example it is “«1» March 2021"), enter the following expression:

FORMAT("«{0}» {1} {2}", LIST(DATETIMEDAY($date), IF ((DATETIMEMONTH($date) == 1), "January", IF ((DATETIMEMONTH($date) == 2), "February", IF ((DATETIMEMONTH($date) == 3), "March", IF ((DATETIMEMONTH($date) == 4), "April", IF ((DATETIMEMONTH($date) == 5), "May", IF ((DATETIMEMONTH($date) == 6), "June", IF ((DATETIMEMONTH($date) == 7), "July", IF ((DATETIMEMONTH($date) == 8), "August", IF ((DATETIMEMONTH($date) == 9), "September", IF ((DATETIMEMONTH($date) == 10), "October", IF ((DATETIMEMONTH($date) == 11), "November", "December"))))))))))), DATETIMEYEAR($date)))

where:

$date – Date / Time attribute to be converted into a specific format.