Posting from airtable on a specific date - how does that work?

How To
1

:us: does anyone have an idea?

I want to post on a certain date and when status is set to post, the date is entered in airtable and also the status “post”. i thought this might work. but i get an error message.
“{status} = “”post” and ‘ {post date}’ < now

hat jemand eine idee?

Ich möchte zu einem Bestimmtem datum posten und wenn status auf posten steht, das datum ist in airtable eingetragen und auch der status “posten”. ich dachte das hier könnte funktionieren. es kommt aber eine fehlermeldung.
"{Status} = ““posten” and " {Post Datum}” < now

2

Hi Sven.,
Airtable prefers its native date functions. Use AND({status} = “post”, {post date} < NOW()). This is the most reliable method. If you must use formatDate() in Make.com, ensure the resulting format exactly matches the Airtable field, and pay close attention to consistent time zones.

You have two potential solutions:

{{status}} = “post” AND formatDate({{post date}}, “YYYY-MM-DDTHH:mm:ssZ”) < formatDate(now, “YYYY-MM-DDTHH:mm:ssZ”)

This option explicitly formats the dates in Make.com before comparing them.
Pros: You have full control over the date format.
Cons: Airtable might have issues with directly using formatDate() in filters. Airtable’s native date functions are generally preferred. Also, time zone issues can arise.
AND({status} = “post”, {post date} < NOW())
This option uses Airtable’s native date comparison functions.
Pros: More reliable, as it uses Airtable’s functions. Less prone to formatting and time zone issues.
Cons: Less control over the exact formatting in Make.com.
Recommendation:

The second option (AND({status} = “post”, {post date} < NOW())) is the better choice in most cases. It’s simpler, more robust, and less prone to errors.

Use the first option only if you have specific reasons to control date formatting in Make and are certain that all time zones are handled correctly.