| Excerpt |
|---|
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:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: serialnumber(date(2015,02,15)) |
|---|
|
serialnumber(date(2015,02,15)) |
Output: Returns the serial date number for February 15, 2015.
Column reference values:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: dateformat(date(myYear, myMonth, myDay)) |
|---|
|
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.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:serialnumber(date_col) |
|---|
|
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_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.
| Required? | Data Type | Example Value |
|---|
| Yes | Datetime (literal,column reference, or function) | DATE(2020,01,02) |
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:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'datSerialNumber' |
|---|
| Type | step |
|---|
| WrangleText | derive type: single value: serialnumber(date(Year, Month, Day)) as: 'datSerialNumber' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | serialnumber(date(Year, Month, Day)) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
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 |
