# Filter not working? **URL:** \ **Category:** Questions\ **Tags:** notion\ **Created:** [March 1, 2024, 8:26am UTC](https://community.make.com/t/filter-not-working/29146 "2024-03-01T08:26:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 8:26am UTC](https://community.make.com/t/filter-not-working/29146/1 "2024-03-01T08:26:28Z")
Hello, I’m trying to automate the sending of a message to Android via Make ou of my Notion DB, on a certain date, to remind me of an action to take. I manage to make it work when I create a field e.g. “Date-x” and my Make “search object” scenario has a filter: "`Date-x" /formula: checkbox - equals" = true`. However, to simplify things and avoid having to create this “Date-x” field in my DB, I’d like to use a Make filter. So I create a “search object” without a filter, and add a filter like this: “`formatDate(37. properties[].date.start; DD-MM-YYYY) = addDays(formatDate(now; DD-MM-YYYY); 30)`”. Here x=30. But it doesn’t detect anything. Thanks in advance for your help. ![Make auto1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/6/86d981f657f65e597979e85a7d7b78fcecd504a0.png) ---
**Author:** ![Philippe\_Billet](https://avatars.discourse-cdn.com/v4/letter/p/dc4da7/32.png) [@Philippe\_Billet](https://community.make.com/u/Philippe_Billet)\ **Post date:** [March 1, 2024, 8:33am UTC](https://community.make.com/t/filter-not-working/29146/2 "2024-03-01T08:33:07Z")
Hi @CharlyMoriaud , According to your screenshot, it appears that there is a mistake in your second function, you entered the “addDays” function directly with your keyboard, it should be selected using your mouse in the date/time function panel. I hope it helps. BR, PBI ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 10:17am UTC](https://community.make.com/t/filter-not-working/29146/4 "2024-03-01T10:17:07Z")
Thansk a lot, I feel stupid… 😉 But it stills does not fetch the record where my Date.Start = 01-04-2024… By the way I have also modified the first filter that was wrong too… ![Make auto2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/f/3fcca400faee14047c0a2dab785620a1c326eba4.png) Any idea ? ---
**Author:** ![Philippe\_Billet](https://avatars.discourse-cdn.com/v4/letter/p/dc4da7/32.png) [@Philippe\_Billet](https://community.make.com/u/Philippe_Billet)\ **Post date:** [March 1, 2024, 10:36am UTC](https://community.make.com/t/filter-not-working/29146/5 "2024-03-01T10:36:03Z")
I have to say that the way to introduce functions with Make can give me a headhache. There is a logical error in the second part of your filter, there is no date such that date = date + 30 days ; in your first screenshot you used “now”, and in the last one, you do not. ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 1:47pm UTC](https://community.make.com/t/filter-not-working/29146/6 "2024-03-01T13:47:39Z")
Oh, I feel stupid 2 times… Here’s my latest modification. Still doesn’t work, though I see that in the Notion search, it was correctly detected ![Make auto2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/3/83c35dfde2334fc467149fd7b5023ff53e09e31c.png) ![Make auto3](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/4/d455d9125edb44aac0a7cbbce3afd476053e826c.png) ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 2:00pm UTC](https://community.make.com/t/filter-not-working/29146/7 "2024-03-01T14:00:00Z")
Hi @CharlyMoriaud, try using {{37.Properties **Value** :Date.Start}} instead of {{37.Properties **[]** Date.Start}} That is where the value is stored 🙂 In addition; you have to adjust the formula for the ‘add days’: {{formatDate(“( " + addDays(now; 30); " DD/MM/YYYY”)}} This way you 1. Add 30 days to Today 2. Reformat this future date to DD/MM/YYYY ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 2:38pm UTC](https://community.make.com/t/filter-not-working/29146/8 "2024-03-01T14:38:03Z")
Hum, thanks @AutoPilots, this is cool, I had never done this. Concerning the formula, I got It ! I have it now like in the screenshot but still doesn’t pick the record where the start date is now+30days (Bundle 2). ![Make auto4](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/c/4cd052374aed542a4654aa88e2d72f8c82fb380b.png) ![Make auto5](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/1/1140e54cadffc1e4ac21ab93a3ff5e0be28a3dca.png) ---
**Author:** ![PierreL](https://avatars.discourse-cdn.com/v4/letter/p/45deac/32.png) [@PierreL](https://community.make.com/u/PierreL)\ **Post date:** [March 1, 2024, 2:46pm UTC](https://community.make.com/t/filter-not-working/29146/9 "2024-03-01T14:46:40Z")
Hi @CharlyMoriaud, Maybe 1 thing to have a look at: - What if you remove the `FormatDate` function wrapped around your `Dates.Start` field? As your `Dates.Start` is already formatted in the right way, there is no need to format it again. ---
**Author:** ![PierreL](https://avatars.discourse-cdn.com/v4/letter/p/45deac/32.png) [@PierreL](https://community.make.com/u/PierreL)\ **Post date:** [March 1, 2024, 2:49pm UTC](https://community.make.com/t/filter-not-working/29146/10 "2024-03-01T14:49:55Z")
it also looks like the correct formatting should be `YYYY-MM-DD` instead of `DD-MM-YYYY` in your filter ---
**Author:** ![PierreL](https://avatars.discourse-cdn.com/v4/letter/p/45deac/32.png) [@PierreL](https://community.make.com/u/PierreL)\ **Post date:** [March 1, 2024, 2:51pm UTC](https://community.make.com/t/filter-not-working/29146/11 "2024-03-01T14:51:02Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/f/8f7d85e95e3ca3e54de5ef4b7378a22fc2d66f5c.png) ---
**Author:** ![PierreL](https://avatars.discourse-cdn.com/v4/letter/p/45deac/32.png) [@PierreL](https://community.make.com/u/PierreL)\ **Post date:** [March 1, 2024, 2:54pm UTC](https://community.make.com/t/filter-not-working/29146/12 "2024-03-01T14:54:41Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/0/d0461ca43d5dafa4f738af7fecd7bccf4c77d3d0.png) ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 2:56pm UTC](https://community.make.com/t/filter-not-working/29146/13 "2024-03-01T14:56:17Z")
@CharlyMoriaud I’m not sure, but it seems there is a space in your formula (the upper part) before DD-MM-YYYY ![CleanShot 2024-03-01 at 15.56.52](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/7/0715ebbb6eaae7e905c00bef780331278f4783f8.png) ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 3:23pm UTC](https://community.make.com/t/filter-not-working/29146/14 "2024-03-01T15:23:31Z")
Oh my ! I removed the space, change the order for YYYY-MM-DD, and remove also the formatDate… Ouch… The “Start” is a date field (screenshot). It still doesn’t work but thanks a lot @PierreL et @AutoPilots for your help so far ! ![Make auto6](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/0/9085817344579a6886f2991dba9ac0beeb442496.png) ---
**Author:** ![PierreL](https://avatars.discourse-cdn.com/v4/letter/p/45deac/32.png) [@PierreL](https://community.make.com/u/PierreL)\ **Post date:** [March 1, 2024, 3:25pm UTC](https://community.make.com/t/filter-not-working/29146/15 "2024-03-01T15:25:42Z")
Could you please share your latest `filter` screenshot please? There is no reason for a `filter` to fail: we’ll find out! ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 3:28pm UTC](https://community.make.com/t/filter-not-working/29146/17 "2024-03-01T15:28:17Z")
Did the filter work, when you just removed the space? There are always multiple options. I think the formulas you had were fine so no need to remove them in my opinion… 🙂 ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 3:30pm UTC](https://community.make.com/t/filter-not-working/29146/18 "2024-03-01T15:30:38Z")
You mean I should go back to switch the addDays and the formatDate ? ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 3:30pm UTC](https://community.make.com/t/filter-not-working/29146/19 "2024-03-01T15:30:50Z")
And additional point: when you make your own format “DD-MM-YYYY” the value becomes a text value, so in that case you have to use the “text: equal to” instead of “Datetime operator: equal to” ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 3:32pm UTC](https://community.make.com/t/filter-not-working/29146/20 "2024-03-01T15:32:40Z")
remove the space (green arrow): ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/6/b65aae75727769d6e5e804844424bd8af86a5ce5.jpeg) Keep the formulas. Output from both fields will be a text string, so the operator should me text: equal to Hope that works ---
**Author:** ![CharlyMoriaud](https://avatars.discourse-cdn.com/v4/letter/c/ea666f/32.png) [@CharlyMoriaud](https://community.make.com/u/CharlyMoriaud)\ **Post date:** [March 1, 2024, 3:34pm UTC](https://community.make.com/t/filter-not-working/29146/21 "2024-03-01T15:34:02Z")
One question I have anyway is why use a filter after the first Notion search module ? Would it not be wiser to include a filter in the module ? So it picks up only the records that match the filter directly ? This would avoid fixing an arbitrary limit (now it’s 20)… Excuse my french… I hope you get what I’m trying to say. 😉 ---
**Author:** ![AutoPilots](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/autopilots/32/29755_2.png) [@AutoPilots](https://community.make.com/u/AutoPilots)\ **Post date:** [March 1, 2024, 3:34pm UTC](https://community.make.com/t/filter-not-working/29146/22 "2024-03-01T15:34:51Z")
Yes that makes sense, to include it in the first module [Next page](https://community.make.com/t/filter-not-working/29146.md?page=2)