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?
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
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!
Try this Formatter config
Aha, brilliant. Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.