Notification for Current Date and Date Field

GGSF

I want an automation to run wherein it compares today's date with a set date in a field. If today's date is less than 30 days than the date field, a notification will be sent.

Tried to create an automation based on date. But the only option is to compare a field to a date that I need to specifically set. What I need is to compare today's date with a date in a field.

Thanks!

Melissa Yamada

Hello @GGSF

It might be helpful to use another helper date column wherein it returns the date in your "Date Field" if today's date is less than 30 days otherwise show today's date. Then use this helper date column on your automation.

=IF(TODAY(-30)<[Date Field]@row,[Date Field]@row,TODAY())