The DAYOFWEEK function returns the day number from the current date. DAYOFWEEK can be used in conjunction with the DAYNAME function to obtain the name of the current day.
Category
Date / Time
Syntax
DAYOFWEEK()Parameter and Description
This function has no parameters.
Example
This example returns the value 5, assuming the current date is Friday, December 12th, 2000 and map the result to target field TGT_DAY_NUMBER.
TGT_DAY_NUMBER = DAYOFWEEK()