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

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: