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
