WEEKDAY Function
Function Type | Predefined function | |
Syntax | WEEKDAY( <dateValue> ) | |
Description | Returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week for a date argument. | |
Argument | Description | |
<dateValue> | Any Date or TimeStamp data type. If <dateValue> is Null, this function returns Null. | |
Returns | Integer | |
Example | This example returns the weekday value (1-7) in the source field, THE_DATE. WEEKDAY(Source.Table.THE_DATE) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*