Derivation Step of Type Step Function
[Rate this topic]

Function

Description

Add

Adds a numeric constant to the value of a specified field.

Age

Calculates the age in years between two date fields; requires two date fields.

Subtract

Subtracts a numeric constant from the value of a specified field (or vice versa, depending on the order of the steps).

Multiply

Multiplies a numeric constant by the value of a specified field.

Divide

Divides a numeric constant by the value of a specified field.

AddDay

Adds a specified number of days (specified as a numeric constant) to a date field; returns a new date.

AddMonth

Adds a specified number of months (specified as a numeric constant) to a date field; returns a new date.

AddYear

Adds a specified number of years (specified as a numeric constant) to a date field; returns a new date.

AddSec

Adds a specified number of seconds (specified as a numeric constant) to a date field; returns a new time.

AddMin

Adds a specified number of minutes (specified as a numeric constant) to a date field; returns a new time.

AddHour

Adds a specified number of hours (specified as a numeric constant) to a date field; returns a new time.

DaySpan

Calculates the number of days between two date fields; requires two date fields.

TimeSpan

Similar to DaySpan; only, this calculates the time (in minutes) between two time fields; requires two time fields.

Now

Uses the current system time or date as a constant.

StringAdd

Strings together two data strings (that is, text) specified as a constant.

Space

Inserts a space between two data fields.