Search Google Sheet for a date in the past and post to tick tick

[Hiltron]

Hey all, I want to make a personal CRM with a list of contacts so i get a task when i haven’t contact them in two months.

I set up a google sheet with a name, last contacted and next contact column. Last contacted i update whenever i contact them and next contact is 90 days from that date.

I set up the google sheet module to search with a filter of next checkin less than or equal to now and put in some test date like below but get nothing back. Can anyone help me please understand how Make.com can handle this?

Sorry i just signed up today so still learning

Name	Last Checkin	Next Checkin
Person 1	13/06/2024	11/09/2024
Person 2	01/02/2024	01/05/2024

[samliew]

Welcome to the Make community!

You selected a numeric (number) operator when you are trying to compare a date.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

[Hiltron]

Thanks. What does that mean? Are you saying i should use a date operator? What is an example of that? I don’t see a “today” option. Also this is on the Date and Time tab.

[Donald_Mitchell]

@Hiltron

Are you saying i should use a date operator?

In your filter is a dropdown that currently reads “Numeric operators: Less than or…”, that needs to be changed to a Date operator.