Validation for bookings across multiple days?

[SageCat]

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

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…