Any idea of getting weekdays order

Ask for Help
1

Hi

I need to get orders only on weekdays.i need an idea to do this?

Plans to get orders on weekdays and delivery the orders on weekends.

2

You can use Date Math.
Weekday(Date) in a math column will return a number between 1 and 7 representing the day of the week for the supplied date, beginning at 1 for Sunday.
You could then use an if-then-else column to test if the given date is a weekday, ie:

  • If weekday equals 1, then false
  • If weekday equals 7, then false
  • Else true
4 Likes
3

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.