# Sequential Missing Dates from Between two Date Values?

**URL:** https://community.glideapps.com/t/sequential-missing-dates-from-between-two-date-values/56031
**Category:** Ask for Help
**Created:** [December 24, 2022, 9:30pm UTC](https://community.glideapps.com/t/sequential-missing-dates-from-between-two-date-values/56031 "2022-12-24T21:30:30Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![SET](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/set/32/51974_2.png) [@SET](https://community.glideapps.com/u/SET)
#### Post date: [December 24, 2022, 9:30pm UTC](https://community.glideapps.com/t/sequential-missing-dates-from-between-two-date-values/56031/1 "2022-12-24T21:30:30Z")

</div>

Is there a way to create a computing column that generates all the missing sequential dates based on two date values?  
For example.  
Column “Start Date” has value of “15-12-2022”  
Column “End Date” has value of “20-12-2022”  
Column “List of Date” contains the dates ranging from Start to End dates : “15-12-2022, 16-12-2022, 17-12,2022 18-12-2022, 19-12-2022, 20-12-2022” This can either be string or array type but an array type would be preferable.

Additionally, is there a way to list all values i.e. dates, numbers within based on Start and End values?

please educate me.

---

<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: [December 25, 2022, 2:36am UTC](https://community.glideapps.com/t/sequential-missing-dates-from-between-two-date-values/56031/2 "2022-12-25T02:36:07Z")

</div>

To generate a list of dates, you can adapt the technique shown below:

> [@Schedule Tab - dates](https://community.glideapps.com/t/schedule-tab-dates/55916/3):
>
> You can do this in Glide. Here is how…

To filter between a start date and end date, you can use an if-then-else column:

- If date is before start date, then null
- If date is after end date, then null
- Else true

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [December 26, 2022, 1:35pm UTC](https://community.glideapps.com/t/sequential-missing-dates-from-between-two-date-values/56031/3 "2022-12-26T13:35:40Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.