TRANSFORMER

DATETONUMBER

DATETONUMBER is a Transformer calculator function that converts dates to numbers, i.e. the number of milliseconds from Jan. 1, 1970. This makes it possible to compare dates.

In the Result Field drop-down list at the top choose the field that is to contain the result, or create a new one by entering a new name.

Syntax

DATETONUMBER(<date>)

where <date> is the date to be converted. You can choose a date field or enter a date using the format "yyyy-mm-dd".

Example 1

DATETONUMBER("2010-03-26")

DATETONUMBER(${Date})

If the date in the field '${Date}' is March 26, 2010 the result of both of the examples above will be

DATETONUMBER(Date) = 1269558000000

Example 2

Use DATETONUMBER to compare one date with another.

If DATETONUMBER(date1)>DATETONUMBER(date2) then date1 is after date2