# Validation for bookings across multiple days?

**URL:** <https://community.glideapps.com/t/validation-for-bookings-across-multiple-days/84380>\
**Category:** Ask for Help\
**Created:** [September 14, 2025, 6:16am UTC](https://community.glideapps.com/t/validation-for-bookings-across-multiple-days/84380 "2025-09-14T06:16:51Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\
**Post date:** [September 16, 2025, 9:19am UTC](https://community.glideapps.com/t/validation-for-bookings-across-multiple-days/84380/4 "2025-09-16T09:19:22Z")

</div>

Hi all. I actually ended up working this out without the need for javascript. I stumbled across this post by @Darren_Murphy and after a bit of trial and error I got it working! Thanks Darren!

> [@Array of dates between 2 dates - experimental column](https://community.glideapps.com/t/array-of-dates-between-2-dates-experimental-column/52511/4):
>
> Okay, so what I would do: Write both start and end dates to user specific columns Use a pair of single value columns to apply those to all rows in your bookings table Create an if-then-else column: – If SV Start Date is after Booking End Date, then null – If SV End Date is before Booking Start Date, then null – Else true Then do a rollup on the if-then-else column, counting true values. If the result is greater than zero, then you have an overlapping date. NB. I may not have the if-then-el…

---

_[View the full topic](https://community.glideapps.com/t/validation-for-bookings-across-multiple-days/84380)._