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 |
---|
|