# How to filter date before today in Make.com **URL:** \ **Category:** Questions\ **Tags:** google-sheets, filters\ **Created:** [November 18, 2025, 6:44am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385 "2025-11-18T06:44:48Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ellie\_Che](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Ellie\_Che](https://community.make.com/u/Ellie_Che)\ **Post date:** [November 18, 2025, 6:44am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/1 "2025-11-18T06:44:48Z")
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](http://Make.com) and how can I do that. Hope to have your support. Thank you. ![z7236632235466_4578085bc56a85b28d757f7c2037ebbb](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/c/0c2b8ab5fd434bd0db43affea4cac90ffc32b541.jpeg) ![z7236632235380_6c0a98913e1b640ad061b0d255ae76ef](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/200a262fb895fb17d0af8546ff814a17cf991e4e.jpeg) ---
**Author:** ![CodexSolutions](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/codexsolutions/32/16574_2.png) [@CodexSolutions](https://community.make.com/u/CodexSolutions)\ **Post date:** [November 18, 2025, 7:06am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/3 "2025-11-18T07:06:48Z")
Hi @Ellie_Che You can use built-in function plus you can format it to get and match desire format ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/d/8d1817567146f2850e5c640b95bc4678c4f994d3.png) Thank you ---
**Author:** ![Ellie\_Che](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Ellie\_Che](https://community.make.com/u/Ellie_Che)\ **Post date:** [November 18, 2025, 7:22am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/4 "2025-11-18T07:22:56Z")
Thank you @CodexSolutions for your response. I’ve tried but it seems not detect ‘now’ function as yours. Is there any way to check ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/2/822ec26ece220eb8710723291ec7dc41938a579c.png) ---
**Author:** ![CodexSolutions](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/codexsolutions/32/16574_2.png) [@CodexSolutions](https://community.make.com/u/CodexSolutions)\ **Post date:** [November 18, 2025, 7:38am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/5 "2025-11-18T07:38:35Z")
Please use that one under date function variables . ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/2/92b0d36d0d1ff7946706ab529f8f79392fc0e51d.png) thank you ---
**Author:** ![Ellie\_Che](https://avatars.discourse-cdn.com/v4/letter/e/ea5d25/32.png) [@Ellie\_Che](https://community.make.com/u/Ellie_Che)\ **Post date:** [November 18, 2025, 7:42am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/6 "2025-11-18T07:42:13Z")
Wow, it works! Thank you so much ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [November 18, 2025, 8:21am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/7 "2025-11-18T08:21:13Z")
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! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [December 2, 2025, 7:57am UTC](https://community.make.com/t/how-to-filter-date-before-today-in-make-com/96385/8 "2025-12-02T07:57:05Z")