Best answer

Using today's date as a value in a Filter

  • 13 January 2022
  • 4 replies
  • 219 views

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?

icon

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: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

 

Help article for formatting dates and times with the Formatter > Date / Time > Format option: https://zapier.com/help/create/format/modify-date-and-time-formats-in-zaps

 

Help articles for using the Filter app: https://zapier.com/apps/filter/help

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.

Help!  

Userlevel 7
Badge +14

@amoss9999 

Try this Formatter config

 

Aha, brilliant.  Thank you @Troy Tessalone