Forum Discussion
Count of Active Projects between two dates
My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need. I have a table with a Project ID, Start Date...
I would think the dates between should work for this yes?
so something like
calculate(countrows(mydatatable), datesbetween(mydatetable), date1, date2))
note you if you want the dates to be variable, I think min(date1) and max(date2) should probably work
No, that doesn't seem to work. I get a "DatesBetween and DatesinPeriod Function are only accepting date column reference as a first argument" error