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

Getting Started
, , ,
1

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.

Scenario
Scenario1113×370 36 KB

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
Array Between

2

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

3

image
image784×348 21.7 KB

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

1 Like
4

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

image
image573×729 36.3 KB

@Freddy_A refer to this solution.

1 Like