Evaluate

Last Updated On
Print
You are here:

The {Evaluate:} function, available in workflow actions, form rule actions, and task type rule actions, allows for mathematical functions to be performed on numbers and dates.

The table below includes a selection of commonly used {Evaluate} functions. For a full list of possible expressions, please see these helpful online resources:

  • C# Math (scroll to the ‘Methods’ table)
  • DateTime (scroll to the ‘Methods’ table)
  • Time Span (scroll to the ‘Properties’ table)

When used in a workflow trigger comparison, where the {Evaluate} function is generating a date, the entire function needs to be surrounded in single quotes: ‘{Evaluate:ToDateTime(…)}’.

Function

Use

Example

x + y
x – y
x*y
x/y

Simple math functions performed on hardcoded numbers, or you may insert a supported variable.

Syntax: {EVALUATE: x + y}

Example: {EVALUATE: 10 – {FormAnswer:Count}}

Example: {EVALUATE: {FormAnswer:Capacity}*{FormAnswer:Count}}

Abs(x)

Returns the absolute value of a number, or you may insert a supported variable.

Syntax: {EVALUATE: Abs(x)}

Example: {EVALUATE: Abs({FormAnswer:Degrees)}

Max(x, y)

Returns the maximum of two values. You may insert a supported variable.

Syntax: {EVALUATE: Max(x, y)}

Example: {EVALUATE: Max(5, {FormAnswer:Distance})}

Min(x, y)

Returns the minimum of two values. You may insert a supported variable.

Syntax: {EVALUATE: Min(x, y)}

Example: {EVALUATE: Min(0, {FormAnswer:Count})}

Pow(x, y)

Returns a number (x) raised to a power (y). You may insert a supported variable.

Syntax: {EVALUATE: Pow(x, y)}

Example: {EVALUATE: Pow({FormAnswer:Length}, 2)}

Round(x, y)

Returns a number (x) rounded to a specified number of digits after the decimal (y). You may insert a supported variable.

Syntax: {EVALUATE: Round(x, y)}

Example: {EVALUATE: Round({FormAnswer:Length}, 1)}

Sqrt(x)

Returns the square root of a number. You may insert a supported variable.

Syntax: {EVALUATE: Sqrt(x)}

Example: {EVALUATE: Sqrt({FormAnswer:Area})}

ToDateTime(“x”)

Converts a date/time into a format to which functions may be performed. You may insert a supported variable. Please note that quotation marks are required inside of the ToDateTime function. You may also use this function to subtract two dates.

Syntax: {EVALUATE: ToDateTime(“x”).Function(y)}

Example: {EVALUATE: ToDateTime(“{FormAnswer:Date}”).AddDays(10)}

Example (returns hours in a decimal format): {EVALUATE: (ToDateTime({FormAnswer:Date2}”) –
ToDateTime({FormAnswer:Date1}”)).TotalHours}

AddDays(x)           

Adds x number of days to a date. You may insert a supported variable. x may be a negative number to subtract days.

Syntax: {EVALUATE: ToDateTime(“x”).AddDays(y)}

Example: {EVALUATE: ToDateTime(“{FormAnswer:Date}”).AddDays(10)}

AddMonths(x)

Adds x number of months to a date. You may insert a supported variable. x may be a negative number to subtract months.

Syntax: {EVALUATE: ToDateTime(x).AddMonths(y)}

Example: {EVALUATE: ToDateTime(“2020-06-15”).AddMonths(2)}

AddYears(x)

Adds x number of years to a date. You may insert a supported variable. x may be a negative number to subtract years.

Syntax: {EVALUATE: ToDateTime(“x”).AddYears(y)}

Example: {EVALUATE: ToDateTime(“2020-01-30”).AddYears(5)}

StartOfDay(x)

Appends 12:00:00AM to the date.

Syntax: {EVALUATE: StartOfDay(ToDateTime(“x”))}

Example: {EVALUATE: StartOfDay(ToDateTime(“2020-01-30”))}

FirstDayOfMonth(x)

Appends the first day of the month to the date.

Syntax: {EVALUATE: FirstDayOfMonth(ToDateTime(“x”))}

Example: {EVALUATE: FirstDayOfMonth (ToDateTime(“{FormAnswer: Assetas_Month}”))}

EndOfDay(x)

Appends 11:59:59PM to the date.

Please note the order of functions if combining both EndOfDay(x) and LastDayOfMonth(x).

Syntax: {EVALUATE: EndOfDay(ToDateTime(“x”))}

Example: {Evaluate: EndOfDay(LastDayOfMonth (ToDateTime(“{FormAnswer:Assetas_Month}”)))}

LastDayOfMonth(x)

Appends the last day of the month to the date.

Please note the order of functions if combining both EndOfDay(x) and LastDayOfMonth(x).

Syntax: {EVALUATE: LastDayOfMonth (ToDateTime(“x”))}

Example: {Evaluate: EndOfDay(LastDayOfMonth (ToDateTime(“{FormAnswer:Assetas_Month}”)))}

Table of Contents