| Function | Short Description |
|---|---|
| Calc | Calculates a numeric value. |
| ContainsText | Returns TRUE if a given record has a text field which matches the specified text. It can also optionally check shared notes (Note records) linked to the record, and (in the case of Individual records), associated spouse family records. |
| Diff | Returns the difference between two numbers as a positive (a.k.a. absolute) value. |
| Diff | Returns the distance between two Place records (if both have been geocoded). |
| GetContextInfo | Returns information which is relevant to a specific context of use. |
| IsTrue | Evaluates a potentially complex expression and determines if it is true or not. |
| LastUpdated | Returns the date that a given record was last updated. Used in all of the Last Updated… queries. |
| NumberIf | Takes a boolean expression (True or False) and 2 numbers. If the boolean expression evaluates as True, the first number is returned; otherwise the second number is returned. |
| TextToNumber | Converts a string expression to a number. |