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.


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


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment