| Excerpt |
|---|
Derives the numeric value for the week within the year (1, 2, etc.). Input must be the output of the DATE function or a reference to a column containing Datetime values. The output of this function increments on Sunday. |
| Info |
|---|
NOTE: If the source Datetime value does not include a valid input for this function, a missing value is returned. |
Column reference example:
| D code |
|---|
derive type:single value:WEEKNUM(MyDate) |
Output: Generates a column of values containing the numeric week number values derived from the MyDate column.
| D code |
|---|
derive type:single value:WEEKNUM(datetime_col) |
| Argument | Required? | Data Type | Description |
|---|
| datetime_col | Y | datetime | Name of column whose week number values are to be computed |
datetime_col
Name of the column whose week number value is to be computed.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
| Tip |
|---|
Tip: You cannot insert constant Datetime values as inputs to this function. However, you can use the following: WEEKNUM(DATE(2017,12,20)). |
| Required? | Data Type | Example Value |
|---|
| Yes | Datetime | myDate |
Example - Day of Date functions
| Include Page |
|---|
| EXAMPLE - Day of Functions |
|---|
| EXAMPLE - Day of Functions |
|---|
|
