Function reference
Gets the day of the week of a date value and returns the number of the weekday.
DayNumber ( date )
| Argument | Description |
| date | The date from which you want the number of the day of the week. |
value1 > value2
Data type: Integer
Returns an integer (1–7) representing the day of the week of date. Sunday is day 1, Monday is day 2, and so on.
Example:
This expression returns Wrong Day if the date in [data] is not a Sunday or a Monday:
If ( DayNumber( Date([data]) ) > 2 , “Okay” , “Wrong Day” )
Last modified:
23 May 2021