Please enable JavaScript to view this site.

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 Descriptions

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