SERIALNUMBER Function
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.
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
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.
Syntax and Arguments
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. |
For more information on syntax standards, see Language Documentation Syntax Notes.
date_col
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.
Usage Notes:
Required? | Data Type | Example Value |
---|---|---|
Yes | Datetime (literal,column reference, or function) | DATE(2020,01,02) |
Examples
Dica
For additional examples, see Common Tasks.
Example - serial date numbers
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:
Transformation Name | |
---|---|
Parameter: Formula type | Single row formula |
Parameter: Formula | serialnumber(date(Year, Month, Day)) |
Parameter: New column name | 'datSerialNumber' |
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 |