Returns the local date and/or time formatted as specified.


FormatDate(date, format, timeZone)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category Yes/No
Business Rules: Before-Save Rules Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) Yes
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) Yes
Business Rules: Editing Rules Yes1
Business Rules: Initialization Rules Yes
Business Rules: Read Only Rules No
Business Rules: Required Rules Yes1
Business Rules: Validation Rules Yes1
Client Expressions No
Object Permissions No
Services Yes
Mobile Yes
Quick Actions (except UI Quick Actions) Yes
UI Quick Actions No
Reports Yes
Search/Dashboard without field references Yes
Search/Dashboard with field references Yes
1. Except when this field appears on a form or is triggered by such a field.


date The date and/or time to format.
format The format for the date and/or time.  See for information about the accepted formats.

(Optional) The time zone, in IANA format.

Return Value

DateTime value.


$(FormatDate(ResolvedDateTime, "dd.MM.yyyy hh:mm"))

If the value of the ResolvedDateTime field is April 14, 2017 at 1:25pm, the above example returns 14.04.2017 13:25.