How I can set up a BETWEEN condition that requires an array of two values in a filter?

[Alvar_RF]

Hello, this kind of silly rookie question, but I’m trying to get a set of deals from HubSpot that have a close date between 03/01/2023 to 07/30/2023 in to a google sheets spreadshet. I use the HubSpot CRM Search for a deal module.

The problem is that I don’t know how to set up properly the filter option between this range of dates. I’m trying to do it, but obviously went wrong

[Freddy_A]

Did you solve this problem? I’m dealing with the same error
Thanks

[Freddy_A]

I managed to solve this by using Make function to create an array

[M.Jasani]

The solution is to employ two conditions, and when both conditions are satisfied, you will obtain the deals that fall within the desired range.

@Freddy_A refer to this solution.