Forum Discussion

MatthewDiMarco's avatar
MatthewDiMarco
Qrew Trainee
6 years ago

How many projects are active in a given month?

I have about 50 or so active projects that span over several months, some are wrapping up, others are starting up. I've added start and end dates, but I cant seem to figure out how to calculate how ma...
Formulas and functions
reports and charts
MatthewDiMarco's avatar
MatthewDiMarco
Qrew Trainee
6 years ago
I made a field for November. The formula seems to result in "1" no matter of the start date. Can you review the formula below and let me know what I'm missing? Also, what number do I adjust to be the next month's field? Does it reset in Jan?

var date ActiveMonthStart = FirstDayOfMonth(AdjustMonth(Today(),2)); 
var date ActiveMonthEnd = FirstDayOfMonth(AdjustMonth(Today(),2));

If(
[Est Installation Start Date]<= $ActiveMonthEnd 
and
[Est Completion Date] >=  $ActiveMonthStart,1,0)