Hi - I’m looking to do an if and statement with two dates. If between X and Y date, then label it as “A” else “B”.
But I am having trouble with finding the date value equivalent in airtable.
In Excel I would do:
IF(AND(CELL1>=DATEVALUE(“04/01/2020”),...
Hi - I want to run an automation where, on a repeated cadence, send out a personalized email, if date range matches my specified date.
How it should look:
Every 3rd week of the Month (Trigger)Look up records with Date Range within the previous month ...
