How to test if a date is part of certain periods (each defined by a start date and end date)

Hello everyone,
here my very first post on this community :slight_smile:
I am working on a use case to learn how to use make.
My idea was to create a simple booking system for a room (like airbnb for example).
The back end will be done qith airtbale (so that I can learn how to use another new tool :))
For the pricing, I have increase the difficulty by adding some high seasons (defined by an start date, and end date).

But unfortunately, I got lost in the repeater, array, and map(), get() function.
I would highly appreciate your help to debug my scenario.

I will attached my scenario:
back-end booking system.json (155.0 KB)

and also here some screenshots:

Hey Jacques,

can you share a screenshot of the setup of the module in question and how you are currently checking? An if() function should do the trick here.

1 Like

Dear Stoyan,
thanks a lot for your answer. I’ve struggling the entire week on this little challenge.
but I guess that’s how you learn :slight_smile:

Quick reminder of the problematic:
I have as input:
(i) a booking request, which is basically X dates (let’s take as an example a booking of 4 days)
(ii) a list of high season periods (for example christmas, summer holidays, etc.). In my case 8 seasons.
Those date are stored in Airtable database

My strategy so far:

  • I have used a repeater to created the 4 booking dates.
  • I get the info regarding the 8 seasons and then use an iterator to have them in 8 separate bundles.
  • Then, as you advised, I have used a module “set variables” with a “if” formula (see screenshot below) to check if each dates are within one of the 8 periods. My problem is that this returns 28 bundels (4 dates x 8 seasons).

Now, I need to find a way to check through those 28 bundles in filter the correct one.
For example, if a date is in 1 high season, it will also have 7 other bundles saying “low season”…

Screenshot of the entire scenario:

Thanks a lot for taking the time to read
I wish you a nice weekend
Jacques

Here an export of my updated scenario:
blueprint (3).json (201.0 KB)