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.

samliewrequest 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

samliewrequest 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

samliewrequest 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!