# Filter for date is not working **URL:** \ **Category:** Questions\ **Tags:** format-date\ **Created:** [June 4, 2024, 1:53pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220 "2024-06-04T13:53:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 4, 2024, 1:53pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/1 "2024-06-04T13:53:11Z")
I have the following filter in the **Get Emails** module, but it does not seem to work ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/8/98531d76ef9c52b1230d62f125e58cb13c1b679e.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/d/bdd5789c70d4a60f75fa8b6c6187205d7df5bb6f.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/80ca837e643853b3e2ea9a84cc8a2b5bea2f24f1.png) ---
**Author:** ![ManishMandot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/manishmandot/32/25887_2.png) [@ManishMandot](https://community.make.com/u/ManishMandot)\ **Post date:** [June 4, 2024, 2:04pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/3 "2024-06-04T14:04:27Z")
Hey @Sam_Krausz Try like this ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/a/8ab752e9c2dad122d1b613fb655e946c9359b4c4.png) > {{formatDate(addMinutes(now; -10); “DD/MM/YYYY HH mm”; “America/New\_York”)}} ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 4, 2024, 2:11pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/4 "2024-06-04T14:11:21Z")
The Same, nothing changed ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 4, 2024, 3:58pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/5 "2024-06-04T15:58:56Z")
Any help or ideas on how to get the filter for date to work? I really need this to work. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 4, 2024, 5:26pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/6 "2024-06-04T17:26:18Z")
I don’t think you even need the formatDate function there. Remove it. [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to **chat** with us! ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 4, 2024, 6:04pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/7 "2024-06-04T18:04:09Z")
Removed , but still the same issue ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/8/88a2a4050cd4594684f4829a29634bee8a0654ee.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/0/f024629a2f87e5034f863503ef88f6172ed3d191.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/7/67df7e0de1583835e60847f01a17081ade815266.png) ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 5, 2024, 12:53am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/8 "2024-06-05T00:53:27Z")
Maybe it’s a bug? it doesn’t make sense Any Idea? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 5, 2024, 5:02am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/9 "2024-06-05T05:02:15Z")
If in doubt, we need to consult the Gmail API. According to [Searching for Messages](https://developers.google.com/gmail/api/guides/filtering), the accepted two formats for Gmail are ## (date only - no hours, minutes, seconds, tz) ```plaintext after:2014/01/01 ``` ## (seconds only, no tz) ```plaintext after:1388552400 ``` Therefore you will still need a `formatDate` to convert the date into a string format that Gmail accepts. ## (date only - no hours, minutes, seconds, tz) ```plaintext {{ formatDate(now; "YYYY/MM/DD") }} ``` ## (seconds only, no tz) ```plaintext {{ formatDate(now; "X") }} ``` For more information, see date formats below: Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### General - [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) - [Make Academy](https://academy.make.com) – learn Make and get your certificate - [Discord Server](https://samliew.com/make-discord-invite) – join us in live chat for fans of Make! ### Help Center Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to **chat** with other makers! ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 5:20am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/10 "2024-06-05T05:20:37Z")
It works for me. The output date is the date you received the email. If no emails exist within the criteria, it returns no bundles. But in this case, I don’t see anything wrong with your output. You got 1 bundle, which is within your criteria. Also your “Set Variable” has a bad date syntax. You forgot a “:” (HH:mm) And also, formatDate(addMinutes()) is the right one. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 5, 2024, 5:27am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/11 "2024-06-05T05:27:56Z")
> [@theoslasha](#): > > You got 1 bundle, which is within your criteria. This is incorrect, as shown in a screenshot above, Query: after 9AM Actual: email was sent at 12AM (9 hours before, outside of the filter) [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/80ca837e643853b3e2ea9a84cc8a2b5bea2f24f1.png) ](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/0/80ca837e643853b3e2ea9a84cc8a2b5bea2f24f1.png) > [@theoslasha](#): > > Also your “Set Variable” has a bad date syntax. You forgot a “:” (HH:mm) This is also incorrect, the colon was clearly there as seen in the first screenshot [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/8/98531d76ef9c52b1230d62f125e58cb13c1b679e.png) ](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/8/98531d76ef9c52b1230d62f125e58cb13c1b679e.png) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers! ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 6:05am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/12 "2024-06-05T06:05:23Z")
> [@samliew](#): > > the colon was clearly there as seen in the first screenshot I was clearly referring to the “Set Variable” module. Not the “Get Emails” module. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 5, 2024, 6:12am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/13 "2024-06-05T06:12:29Z")
> [@theoslasha](#): > > I was clearly referring to the “Set Variable” module Yes, but that wasn’t posted by Sam, the original question asker. ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 6:23am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/14 "2024-06-05T06:23:56Z")
> [@samliew](#): > > Yes, but that wasn’t posted by Sam, the original question asker. Sorry for noticing… ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 6:31am UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/15 "2024-06-05T06:31:20Z")
This should be simple. Either way, I think all apparent solutions must be tested. It works perfect for me. Another thing I noticed is that it works with my Drive connection for some reason. I would also suggest checking your timezones once more. It smells like a timezone difference. ![Screenshot 2024-06-05 063107](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/0/70d82055ce5d6fb7af8f69f5bc8e1757a6796864.png) ![Screenshot 2024-06-05 080947](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/5/35478dda0c5bf16f49f8929a4136e1cecab9b97e.png) ![Screenshot 2024-06-05 081036](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/3/1357e9d3c68a0dab6eff8bf2cb30a38c0e2c3f51.png) ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 5, 2024, 2:56pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/16 "2024-06-05T14:56:54Z")
I only selected seconds, but I’m still receiving all emails. Am I doing something wrong? ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/626c0cc6e8f2b1ce636e23feda033890c01f8416.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/0/30e9014cb6ebcc7b126cc13631d9e47549acd6aa.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/7/976ed5465cccd2d2880b1abd0193842e85292619.png) ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 3:57pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/17 "2024-06-05T15:57:19Z")
Please try the format as I have it in my example, just to try it, and then maybe we can move forward. This syntax is not right. ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 5, 2024, 4:17pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/18 "2024-06-05T16:17:51Z")
Its not working - Maybe I am missing something? ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/2/92e3fe5e2013fd295cfb14d53474e18689d89832.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/6/3622445dad959bda2a62dae70b47fb698ef71ba4.png) ---
**Author:** ![theoslasha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theoslasha/32/36943_2.png) [@theoslasha](https://community.make.com/u/theoslasha)\ **Post date:** [June 5, 2024, 8:13pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/19 "2024-06-05T20:13:00Z")
I don’t have enough information to figure this out. Maybe if you share your entire workflow. To see the whole picture. As you wish. ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 5, 2024, 8:19pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/20 "2024-06-05T20:19:33Z")
There is just one module Get Emails - there is no Workflow ---
**Author:** ![Sam\_Krausz](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@Sam\_Krausz](https://community.make.com/u/Sam_Krausz)\ **Post date:** [June 5, 2024, 8:20pm UTC](https://community.make.com/t/filter-for-date-is-not-working/40220/21 "2024-06-05T20:20:16Z")
Hi everyone, I’m really struggling with Filter Issue and haven’t been able to get any solid answers - I’m feeling quite desperate and am begging the community for help. If anyone has experience or knowledge about Filter Date Issue and can provide some guidance or a solution, I would greatly appreciate it. Your help would mean the world to me. Thank you so much in advance for any assistance you can offer! [Next page](https://community.make.com/t/filter-for-date-is-not-working/40220.md?page=2)