Forum Discussion

ArielSantiago's avatar
ArielSantiago
Qrew Member
2 years ago

Count if Active During Certain Period

I need to be able to see which resources were active at any given time. I have both a date hired and date termed, but I think I need a "query date" for something like this to work? For example, if 50 employees were active between Jan 1, 2020 - May 5, 2020, I need the report to show me those 50 employees. Is this possible?

------------------------------
Ariel Combs
------------------------------
Formulas and functions
reports and charts

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    There is an elegant way to do this with a table report, and two formula fields. tyhis will be easiest for your users.

    Make a formula date field called [Start Range] with the formula of [Term Date]
    Make a formula date field called [End Range] with the formula of [HireDate]

    Create a table report with this filter.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • ArielSantiago's avatar
      ArielSantiago
      Qrew Member
      2 years ago
      Hi Mark,

      Thanks for the reply, Mark. It worked perfectly!

      ------------------------------
      Ariel Combs
      ------------------------------