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

**URL:** <https://community.glideapps.com/t/can-i-get-a-list-of-all-dates-between-2-date-columns/38481>\
**Category:** Ask for Help\
**Created:** [February 14, 2022, 9:16pm UTC](https://community.glideapps.com/t/can-i-get-a-list-of-all-dates-between-2-date-columns/38481 "2022-02-14T21:16:22Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 15, 2022, 2:20pm UTC](https://community.glideapps.com/t/can-i-get-a-list-of-all-dates-between-2-date-columns/38481/5 "2022-02-15T14:20:06Z")

</div>

> [@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.

---

_[View the full topic](https://community.glideapps.com/t/can-i-get-a-list-of-all-dates-between-2-date-columns/38481)._