Filter for date is not working

I have the following filter in the Get Emails module, but it does not seem to work

Hey @Sam_Krausz

Try like this

{{formatDate(addMinutes(now; -10); “DD/MM/YYYY HH mm”; “America/New_York”)}}

1 Like

The Same, nothing changed

Any help or ideas on how to get the filter for date to work? I really need this to work.

I don’t think you even need the formatDate function there. Remove it.

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

1 Like

Removed , but still the same issue

Maybe it’s a bug? it doesn’t make sense

Any Idea?

If in doubt, we need to consult the Gmail API.

According to Searching for Messages,

the accepted two formats for Gmail are

(date only - no hours, minutes, seconds, tz)

after:2014/01/01 

(seconds only, no tz)

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)

{{ formatDate(now; "YYYY/MM/DD") }}

(seconds only, no tz)

{{ 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 Basics

Articles & Videos

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like

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.

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)

This is also incorrect, the colon was clearly there as seen in the first screenshot

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

1 Like

I was clearly referring to the “Set Variable” module. Not the “Get Emails” module.

Yes, but that wasn’t posted by Sam, the original question asker.

1 Like

Sorry for noticing…

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


I only selected seconds, but I’m still receiving all emails. Am I doing something wrong?

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.

1 Like

Its not working - Maybe I am missing something?

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.

1 Like

There is just one module Get Emails - there is no Workflow

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!