Skip to main content

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?

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!  


@amoss9999 

Try this Formatter config

 


Aha, brilliant.  Thank you @Troy Tessalone