Question

creating a filter to check if a field date is today

  • 15 November 2022
  • 2 replies
  • 32 views

Userlevel 1

Is it possible to create a filter in order to check if a date field , for instance payment day is today?

I´d like to check this dynamic info before run the zap. Is it possible?

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @acaruso 

Good question.

 

You could add a formula column in the GSheet to check if the Date = Today.
 

OR try using a Formatter > Date / Time > Compare Dates step in the Zap which will output whether the Dates are the same to then check that variable in the Filter step.

 

Otherwise, I’d recommend using Airtable instead of GSheets.

Airtable has Views.

Views have Filters. (e.g. Date = Today)

Views can be used to trigger Zaps.

Userlevel 5
Badge +7

Hey there @acaruso - just checking that you were able to set up your Zap with Troy’s advice above? Let us know!