Replacement Function Tags

The following table provides the list of available Tag Functions that can be used within the all system emails.

Function tags are written within the HTML body and must be contained within opening and closeing double brackets - "[[" and "]]", for example:

[[@IFERROR(@FORMATDATE(@ADDDAYS(@LATER([PurchaseDate], [LastServiceDate]), 366), "MMMM d, yyyy"), "a date in the near future")]]

In the example above, a function is indicated by the use of double square brackets, and the @ sign is a character that indicates a function is being performed, and in this example a function can contain a function and order of operations is from the inside out). The parameters can be replacement tags by the use of square bracket syntax, though actual values could be submitted by not using brackets around the parameters.

If a function cannot evaluate a result, has invalid parameters, or a calculation error occurs, then an blank string is returned.

General Functions

Function	Description
@VOID()	Do nothing. (Most cases use this as a fallback/system function)

Date Functions

Function	Description
@LATER(date1, date2,..., daten)	Compare the two or more date/time values and determine which occurs after the other, and return that later value.
@EARLIER(date1, date2, ..., daten)	Compare two or more date/time values and determine which occurs before the other, and return that earlier value.
@DATEDIFF(date1, date2)	Returns the difference between two dates, including years, months, days like 1 year, 4 months, 3 days
@DATEDIFFDAYS(date1, date2)	Returns the difference between two dates, in days.
@ADDDAYS(date, numDays)	Using a date value, add a number of days to it and return it. A negative number subtracts that number of days from the date and returns a previous date.
@ADDMONTHS(date, numMonths)	Using a date value, add a number of months to it and return it. A negative number subtracts that number of months from the date and returns a previous date.
@ADDYEARS(date, numYears)	Using a date value, add a number of years to it and return it. A negative number subtracts that number of years from the date and returns a previous date.
@FORMATDATE(date, "formatString")	Formats the date using the specified string. Available format strings can be found at https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

 Math Functions

Function	Description
@SUM(number1, number2,... numbern)	Add together two or more numeric values (integer or real) and return the calculated total
@SUBTRACT(number1, number2,... numbern)	Calculate the diffierence between two or more numbers. The calculation is performed form left to right.
@MULTIPLY(number1, number2,... number n)	Multiply two or more numbers to evaluate the product.
@DIVIDE(number1, number2)	Calculate the quotient of two numbers by dividing the first parameter by the second.
@AVERAGE(number1, number2,... numbern)	Calculate the average of two or more numbers by deriving the sum of all the numbers and divide by the total quantity of numbers.
@MOD(number1, number2)	Calculate the remainder (or modulo or modulus) when dividing two numbers. The first parameter is divided by the second and the result is the remainder, or 0 if no remainder.
@FORMATNUMBER(number, "formatString")	Formats a number in the specifed format. Available formats as listed at https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings

 Logical Functions

Function	Description
@IFERROR(@FUNCTION, then)	Returns a value you specify if a @FUNCTION evaluates to an error; otherwise, returns the result of the FUNCTION