Expression as a value

The user can specify expression instead of immediately entered value of reference to another field.
Syntax: $$(expression text)

An expression can contain: constants, operations and references to field value as @'field name'.

Operations

Operations '*','/' and unary '-' are acceptable for numeric operands only.

The '+' operation

Right operand
Left operandIntegerFloatDateTime
Integer++ (float)Add N daysAdd N seconds
Float+ (float)+N/AN/A
Dateadd N daysN/A N/AN/A
Timeadd N secondsN/A N/AN/A

The '-' operation

Right operand
Left operandIntegerFloatDateTime
Integer-- (float)N/AN/A
Float- (float)+N/AN/A
Datesubtract N daysN/A N/AN/A
Timesubtract N secondsN/A N/AN/A

Notes and limitations:

  • '(' and ')' can be used with any acceptable data type.
  • Complex nested expressions like $$($$(8-2)-2) are not acceptable, use '()' instead of. Example: $$((8-2)-2)

Example: 'HireDate' must be greater than 'BirthDate' + 18 years (265*18 days):

DTM Data Scrubber: expression in the verification rule