| Excerpt |
|---|
Generates a date value from three inputs of Integer type: year, month, and day. |
- Source values can be Integer literals or column references to values that can be inferred as Integers.
- If any of the source values are invalid or out of range, a missing value is returned.
- This function must be nested within another function that accepts date values, such as
DATEFORMAT, as arguments. See the example below.
Integer literal values:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: dateformat(date(2015,02,15),'yyyy-MM-dd') |
|---|
|
dateformat(date(2015,02,15),'yyyy-MM-dd') |
Output: Returns the formatted date value: 2015-02-15.
Column reference values:
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: dateformat(date(myYear, myMonth, myDay),'MMM yyyy') |
|---|
|
dateformat(date(myYear, myMonth, myDay),'MMM yyyy') |
Output: Returns date values based on three columns, formatted for date.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:dateformat(date(year_integer_col,month_integer_col,day_Integer_col ),'date_format_string') |
|---|
|
dateformat(date(year_integer_col,month_integer_col,day_Integer_col ),'date_format_string') |
| Argument | Required? | Data Type | Description |
|---|
| year_integer_col | Y | integer | Name of column or Integer literal representing the year value to apply to the function |
| month_integer_col | Y | integer | Name of column or Integer literal representing the month value to apply to the function |
| day_integer_col | Y | integer | Name of column or Integer literal representing the day value to apply to the function |
| date_format_string | Y | string | String literal identifying the date format to apply to the value |
year_integer_col
Integer literal or name of the column containing integer values for the year.
- 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 | Integer (literal or column reference) | 2015 |
month_integer_col
Integer literal or name of the column containing integer values for the month.
- Values must be
1 or more, with a maximum value of 12. - 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 | Integer (literal or column reference) | 4 |
day_integer_col
Integer literal or name of the column containing integer values for the day.
- Values must be
1 or more, with a maximum value for any month of 31. - 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 | Integer (literal or column reference) | 26 |
String literal that describes how the date value is formatted.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal value | 'yyyy-MM-dd' |
For more information, see DATEFORMAT Function.
Example - date and time functions
| Include Page |
|---|
| EXAMPLE - DATE and TIME Functions |
|---|
| EXAMPLE - DATE and TIME Functions |
|---|
|
