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( DAY($date), IF ( (MONTH($date) == 1), "January", IF ( (MONTH($date) == 2), "February", IF ( (MONTH($date) == 3), "March", IF ( (MONTH($date) == 4), "April", IF ( (MONTH($date) == 5), "May", IF ( (MONTH($date) == 6), "June", IF ( (MONTH($date) == 7), "July", IF ( (MONTH($date) == 8), "August", IF ( (MONTH($date) == 9), "September", IF ( (MONTH($date) == 10), "October", IF ( (MONTH($date) == 11), "November", "December"))))))))))), YEAR($date)))

where:

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