Returns the year day of week of a date, an integer between 1583 1 and 99567.
Syntax
Code Block |
---|
YEARWEEKDAY( date ) |
date
...
format:
...
month/day/year
...
or
...
year-month-day
...
year (required) - An integer between 1583 and 9956, or 0 - 99.
month (required) - An integer between 1 and 12 representing month.
day (required) - An integer between 1 and 31 representing day of month.
Examples
Syntax | Result |
---|---|
report: WEEKDAY("6/21/69") | 7 |
report: WEEKDAY("1969-6-21") | 7 |
BDate = "6/21/69" | 7 |