Count Work Orders Started on Weekdays
I need a report formula that will count the current month's work orders that are started on weekdays only. Any ideas? This is where an am so far: IF (Month([Work Order Start Date]) = Month(Today(...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this as a formula checkbox field
Month([Work Order Start Date]) = Month(Today())
and DayOfWeek([Work Order Start Date]>=1
and DayOfWeek([Work Order Start Date]<=5)
Then you can run a report and filter on this field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Month([Work Order Start Date]) = Month(Today())
and DayOfWeek([Work Order Start Date]>=1
and DayOfWeek([Work Order Start Date]<=5)
Then you can run a report and filter on this field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Month([Work Order Start Date]) = Month(Today())
and DayOfWeek([Work Order Start Date]>=1
and DayOfWeek([Work Order Start Date]<=5)
Its telling me ">=" can not be applied as an operator on date, number.
------------------------------
David Browne
------------------------------
and DayOfWeek([Work Order Start Date]>=1
and DayOfWeek([Work Order Start Date]<=5)
Its telling me ">=" can not be applied as an operator on date, number.
------------------------------
David Browne
------------------------------
- MarkShnier__YouI was missing a few closing brackets
Month([Work Order Start Date]) = Month(Today())
and DayOfWeek([Work Order Start Date])>=1
and DayOfWeek([Work Order Start Date])<=5)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- This worked great. Thank you!
------------------------------
David Browne
------------------------------