Can I get a list of all dates between 2 date columns?

[Jeff_Hager]

This is an excellent use case for this request:

Conditional Relations

I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In…

Your description is probably a lot simpler than mine.

BUT!!!, I think in your case, it’s still achievable since it sounds like a case of one set of From/To dates. In my case, I have hundreds or thousands of rows that need to find a related set of data within a date range that varies for each of the hundreds/thousands of rows. So in reality, my situation seems different from yours.

However, to achieve what you want, if you can add single value columns to your task table, then you can populate the From and To date column value across all rows using single value columns. Then with an IF column, you can run a comparison to see if each row fits within that range and return the number of units if it’s within range, or return zero if it’s not. Then you can rollup the result of that IF column. That way it will only count the units within that date range.