View Source

Generates a serial date number from a valid date value.

Serial date number values begin with January 1, 1900.
Source values can be a valid date or output of a function that generates a valid date.

Integer literal values:

serialnumber(date(2015,02,15))

Output: Returns the serial date number for February 15, 2015.

Column reference values:

serialnumber(date(myYear, myMonth, myDay))

Output: Returns serial date number based on three input columns, which contain valid values for day, month, and year in the calendar.

serialnumber(date_col)

Argument	Required?	Data Type	Description
date_col	Y	Datetime	Date literal, name of column containing valid date values, or function returning a valid date value.

Date literal, column containing date values, or function returning date values. Time values in the input value are not used.

Missing values for this function in the source data result in missing values in the output.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	Datetime (literal,column reference, or function)	`DATE(2020,01,02)`

Source:

eventId	Year	Month	Day
e001	2021	01	01
e002	2021	01	02
e003	2021	01	03
e004	2021	01	04
e005	2021	01	05

Transformation:

Results:

eventId	Year	Month	Day	datSerialNumber
e001	2021	01	01	44197
e002	2021	01	02	44198
e003	2021	01	03	44199
e004	2021	01	04	44200
e005	2021	01	05	44201