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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThere 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
------------------------------
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
------------------------------
Hi Mark,
Thanks for the reply, Mark. It worked perfectly!
------------------------------
Ariel Combs
------------------------------
Thanks for the reply, Mark. It worked perfectly!
------------------------------
Ariel Combs
------------------------------