Reference > Expressions > Built-in Functions > Date Functions > FormatDate

FormatDate

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

Syntax

FormatDate(date, format)

Enabled for

Search/Dashboard No
Business Rules Yes
Quick Actions Yes
Workflow Objects Yes
Reports No

Parameters

date The date and/or time to format.
format The format for the date and/or time.  See http://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx for information about the accepted formats.

Return Value

DateTime value.

Example

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

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