I am tracking some data which is time-sensitive and set up a trigger following Airtable’s recommended steps but I would like to customize it further by having the reminders triggered within 30 days before the due date.
For example - if the item is due on 1 May, I would like the reminder to be triggered in April.
How could I modify the formula?
For reference, this is the existing formula as recommended by Airtable:
IF(
AND(
{Due Date},
NOW() >= {Due Date}
),
“Trigger Reminder”
)
Thank you! Any help would be greatly appreciated.
Page 1 / 1
MODIFY FORMULA to read
NOW()>= {Due Date}-14
for 2 weeks earlier
MODIFY FORMULA to read
NOW()>= {Due Date}-14
for 2 weeks earlier
Thank you so much!! This is great, works perfect!
MODIFY FORMULA to read
NOW()>= {Due Date}-14
for 2 weeks earlier
Welcome to the community, @Ron_Clark! :grinning_face_with_big_eyes: Unfortunately subtracting a number from a date as you indicated doesn’t produce a valid date.
The correct way to modify dates is by using the DATEADD() function. The original formula altered to use this would be:
Welcome to the community, @Ron_Clark! :grinning_face_with_big_eyes: Unfortunately subtracting a number from a date as you indicated doesn’t produce a valid date.
The correct way to modify dates is by using the DATEADD() function. The original formula altered to use this would be: