Forum Discussion

DavidBrowne's avatar
DavidBrowne
Qrew Trainee
5 years ago

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()), Count([Work Order #]))

Thanks.

------------------------------
David Browne
------------------------------
Formulas and functions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    try 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
    ------------------------------
    • DavidBrowne's avatar
      DavidBrowne
      Qrew Trainee
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I 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
        ------------------------------