Array of dates between 2 dates - experimental column

Ask for Help
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-else logic exactly right there - I might have missed a condition or two - but it should give you the idea

3 Likes