HubSpot date property filter not working with addDays(now; -3) in Make

:bullseye: What is your goal?

Filter HubSpot deals in Make where a date property (date__first_wa) is older than 3 days, to trigger a follow-up WhatsApp + email sequence.

:thinking: What is the problem & what have you tried?

My scenario runs every 4 hours and sends a follow-up WhatsApp + email to HubSpot deals. The problem is that the follow-up is being sent immediately when the scenario runs, instead of waiting 3 days after the first WhatsApp was sent.

HubSpot stores the date of the first WhatsApp in a Date property called “date__first_wa” (format: 2026-03-11T00:00:00.000Z).

I want the filter to only let deals pass if date__first_wa is older than 3 days.

What I tried in the Make filter:

  1. Time operators: Less than or equal to → formatDate(addDays(now; -3); “x”) → does not work
  2. Time operators: Less than or equal to → formatDate(addDays(now; -3); “YYYY-MM-DD”) → does not work
  3. Time operators: Less than or equal to → addDays(now; -3) → does not work
  4. Text operators: Contains → formatDate(addDays(now; -3); “YYYY-MM-DD”) → does not work

Deal test:

  • date__first_wa = 2026-03-11T00:00:00.000Z
  • Today = 2026-03-14
  • This deal should PASS (3 days have passed) but it is always BLOCKED

What is the correct way to compare a HubSpot date property with “now minus 3 days” in a Make filter?

:clipboard: Error messages or input/output bundles

Output from HubSpot Search module:

  • date__first_wa: “2026-03-11T00:00:00.000Z”
  • Property type in HubSpot: Date (not DateTime)

Current Make filter:

    1. Properties: Date - First WA
  • Time operators: Less than or equal to
  • addDays(now; -3)

Today’s date: 2026-03-14
Expected: filter passes
Actual: filter blocks

Hey Benjamin ,

You are looking for timedate in the filter, not time.