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?
Answer
Using today's date as a value in a Filter
Best answer by Troy Tessalone
Try this Formatter config
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
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
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.