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):
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.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and Need expert help or have questions? Contact or comment below!