# List All Dates Between Start And End Date

**URL:** https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667
**Category:** Ask for Help
**Created:** [August 15, 2024, 5:42pm UTC](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667 "2024-08-15T17:42:15Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Dustinrt](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@Dustinrt](https://community.glideapps.com/u/Dustinrt)
#### Post date: [August 15, 2024, 5:42pm UTC](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667/1 "2024-08-15T17:42:15Z")

</div>

I Need A Way To List All Dates Between Start Date And End Date To Eliminate Double Booking Someone For The Same Spot During That Time

Anyone Know How To Do This

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 16, 2024, 12:01am UTC](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667/2 "2024-08-16T00:01:05Z")

</div>

I would do it like this (I don’t like working directly with dates in JS, I want to convert it to numbers first).

- Create a column like this in a helper table, writing “1st January 1970” to the first cell.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8783a7e1f33166dc7307a5e18ced38f425b5e20.png)

- Cast that to your Users table with a Single Value column.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b899b85144252e118299f3d0138d05247e349f4.png)

- Go to your bookings table, do this.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96cafb49160029324aa49fa3b10b016887ccc527.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c00e417af26150b3ae77cea85abdf86ee344fc95.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5025c4e6ad4459b74c9f21c97169a586d14f6a6.png)

```auto
return Array.from(
    { length: p2 - p1 + 1 },
    (_, i) => p1 + i
  ).join(', ');

```

Then, when there’s a new booking, you also convert it to this “difference” format and check against the existing list of numbers to prevent double booking.

---

<div class="post-metadata">

### Author: ![GrumpyRick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/grumpyrick/32/18079_2.png) [@GrumpyRick](https://community.glideapps.com/u/GrumpyRick)
#### Post date: [August 16, 2024, 2:52am UTC](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667/3 "2024-08-16T02:52:45Z")

</div>

I have a template called Simple 1 Person Booking Solution that you can start with.

---

<div class="post-metadata">

### Author: ![Dustinrt](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@Dustinrt](https://community.glideapps.com/u/Dustinrt)
#### Post date: [August 16, 2024, 3:54am UTC](https://community.glideapps.com/t/list-all-dates-between-start-and-end-date/75667/4 "2024-08-16T03:54:51Z")

</div>

This Helps So Much,Thank You