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...
This is great, thank you both for the help. however, the real data table I am using is Thousands of lines long. A crossjoin table to have each possible date the project is open is not feasible due to size and performance concerns.