Skip to Content

Pulling elements out of a Date/Time field

This article describes how to extract just separate parts (e.g. day/month/year) from a Date/Time field. This could be useful, for example, to cut off the time when writing a custom description or when sending a custom email notification.

This can be done using the FORMAT function. Here's an example: FORMAT("{0:MM:yyyy}", LIST($creationDate))

Syntax 

  • MM = month
  • yy or yyyy = year
  • dd = day
  • mm = minutes
  • hh = hours
  • ss = seconds