Hello, I have data including date join and exit date in google sheet. How can I run automation that filter out those resigned in the past, which mean their exit date is earlier than today.
Below is my current workflow. I added filter in between 2 modules. It worked if I input the specific date in the set up a filter, but I want it update the date of today automatically. Could it be possible in Make.com and how can I do that.
Hope to have your support. Thank you.
Hi @Ellie_Che
You can use built-in function plus you can format it to get and match desire format
Thank you
Thank you @CodexSolutions for your response. I’ve tried but it seems not detect ‘now’ function as yours. Is there any way to check
Please use that one under date function variables .
thank you
2 Likes
Wow, it works! Thank you so much
In addition to @CodexSolutions’ answer, you can also use the bracket syntax:
typing {{now}} will result in the now variable.
This syntax works for all of the variables!
