How to compare dates within a formula on requesting airtable results?

Hi there Folks,
you helped me so often i am quite sure there will be a fast answer to this ;). Thanks for all the support.

I am trying to filter airtable results on a date - basically i want to understand if there is already an entry for today - if not i will create one. Currently i am trying to understand how date comparing can work for me.

At first, this is how the data looks like (without filter):

As you can see, the date returns as 2024-11-13 (YYYY-MM-DD).

My formula looks like this:

But does not seem to match the date right… any hints? :slight_smile:

Hello @fruits,
As you mention about the Date format 2024-11-13 (YYYY-MM-DD)
Try to use YYYY-MM-DD on the second parameter of formatDate.

For debugging purposes initially try with a single condition like this, Make sure you change the formula according to Make’s syntax.

AND({Send-Date} < formatDate(now; YYYY-MM-DD))

Then use that Mailbox after you successfully get a response of dates.

If Mailbox doesn’t work properly, try also to remove the quotation mark (') from that value of Mailbox.

I hope this helps you.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down: