Gets the day of the week of a date value and returns the number of the weekday.
DayNumber ( date )
|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.
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
Thanks for your feedback.
Post your comment on this topic.