Applies to Infiniti v8.1 or later

Infiniti provides several functions for certain tasks which are grouped under two categories – Formula Functions and Aggregate Functions.

To perform more complex calculations, formulas may also incorporate various math, date and text functions. For example, the DateDiff() function can be used to calculate a person’s age based on their date of birth and today’s date.

Functions require a set of parameters to determine a result. These parameters may be literal values, references to other questions, or even other functions. Functions must include the function name followed by any parameters in brackets, or empty brackets if no parameters are required. Parameters are separated by commas.

- Function Abs()
- Function Chr()
- Function Concat()
- Function DateAdd()
- Function DateDiff()
- Function Errormask()
- Function Format()
- Function IIf()
- Function IsTrue()
- Function Left(), Right() and Substring()
- Function Length()
- Function Now()
- Function ProperCase()
- Function Propercase() - Excluding Abbreviations and Acronyms from Propercase
- Function RangeIndex()
- Function Replace()
- Function Round()
- Function StartsWith() & Ends with()
- Function Today()
- Nested iif() formulas

A collection of aggregate functions are available to perform calculations on questions within a repeating section or page, or a multiple row data source. For example, calculate the total price of individual line items or determine the average purchase order value for a particular client.

Aggregate functions require a reference to a question within a repeating page or section, which may be of any question type, or a multiple row data source question. Aggregate functions examine all the values retrieved to determine a result.

- Function Average()
- Function Contains()
- Function Count()
- Function CountIf()
- Function CountNumber()
- Function First() and Last()
- Function IsEqual(), IsNotEqual (), IsGreaterThan(), IsGreaterThanOrEqualTo(), IsLessThan() and IsLessThanOrEqualTo()
- Function Join()
- Function JoinAnd()
- Function Max() and Min()
- Function NotContains()
- Function StringContains()
- Function Sum()

fxn dateformat contains

Help Desk Software powered by SmarterTrack 12.5

© 2003-2020 SmarterTools Inc.

By using this site, you are accepting cookies to store user state and login information.