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” )

Feedback

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