DAY OF WEEK Function
The DAY OF WEEK function converts a Date variable's answer to a number between 1 and 7 corresponding to the day of the week the date falls on.
Function name | DAY OF WEEK |
Usage model | DAY OF WEEK ( d:DATE ) |
Parameters | This function requires you to replace only one parameter: |
d: DATE |
The function determines the day of the week that this date falls on. |
Result | A number value between 1 and 7, corresponding to the day of the week:
|
Example
A template author wants to know whether a payment due date falls on a Saturday or Sunday. If it does, they move the payment due date to the following Monday. The following script shows how this works:
IF DAY OF WEEK( Payment Date ) = 7
Payment Date + 2 DAYS
ELSE IF DAY OF WEEK( Payment Date ) = 1
Payment Date + 1 DAYS
ELSE
Payment Date
END IF