Hello, I have a question, I want to do an if with a date field that the condition is met if the date is 10 days before the current date, would you know how to do it? Thanks.
Question
How do I check if the date is 10 days before current date with an if statement?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+8- Zapier Orchestrator & Solution Partner
Hi
Can you please explain the workflow more? For example, what happens if the date is not 10 days ago? And where is the date coming from? Is there a Today field in the incoming data?
Hello, yes, the date data comes from mailparser.io and I already have it. What I want is to put certain variables in an excel if the date is from now or 10 days before, I don't know if I'm explaining myself well.
Thank you
+8- Zapier Orchestrator & Solution Partner
Ok, then in this case you would want to insert a formatter step before the Filter. Since you are ysing the email parser this means you are receiving the email Today (so we have the Today date in the result of the Trigger). Use the Compare Date in the formatter to get the number of days between both dates you want to compare. Then in the filter, use Number (greater than / less than, depending on what you need).
Does that make sense?
Ok, I already formatted the date that comes from mailparser but now when doing the condition, what variable do I use to put the current date minus 10 days?
+8- Zapier Orchestrator & Solution Partner
Hi
Please show me the Formatter step details and output.
+8- Zapier Orchestrator & Solution Partner
The setup should be Compare Dates, enter both dates (you should find the Today date already in the trigger, which is the date received for example).
The result will be the difference of the dates. Using this output then you use it in the filter
+8- Zapier Staff
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.