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

[Darren_Murphy]

@Hassan_Nadeem

If “PRODUCTION ASSIGNED DATE” is on or after “DATE FROM COLUMN” and “PRODUCTION ASSIGNED DATE” and is on or before “DATE TO COLUMN” then show “Number of units”. and then I would have rolled up that value to get sum and count.

Do it like this:

• If PRODUCTION ASSIGNED DATE is before DATE FROM COLUMN, then “nothing” (leave it empty)
• If PRODUCTION ASSIGNED DATE is after DATE TO COLUMN, then “nothing” (leave it empty)
• Else Number of units

Then you can do your rollup on that.