Best answer

Using today's date as a value in a Filter

  • 13 January 2022
  • 4 replies

I’m trying to set a filter that checks the Due Date of a task against Today’s date.


Any suggestions on how to set a variable value of today’s date in a filter condition?


Best answer by Troy Tessalone 14 January 2022, 02:58

View original

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

4 replies

Userlevel 7
Badge +14

Hi @amoss9999 

Help article for using the insert timestamp variable:


Help article for formatting dates and times with the Formatter > Date / Time > Format option:


Help articles for using the Filter app:

Thanks @Troy Tessalone I had studied those articles, however I haven’t figured a workaround to address this issue.

The incoming Due Date format is YYYY-MM-DD and there’s no time attached.

The Zapier timestamp is in MM/DD/YY hh:mmAM/PM format.

The filter I am trying to create is to fire my Zap when the Due Date equals today’s date.

I haven’t figured out a way to either add a default time to the incoming date via the Zapier Formatter, OR to reformat the Zapier timestamp (removing the time data) before running the filter.


Userlevel 7
Badge +14


Try this Formatter config


Aha, brilliant.  Thank you @Troy Tessalone