Automation rule based on date field

Is there any way to auto update task State to “overdue” once the Date field value past today? I don’t see any trigger to monitor the date value in the field (not actual time schedule, which is possible).

I think for such things you just have to run a check on a schedule. Is that not an option in your case?

1 Like

I didn’t think about that! Thanks for the quick response!

1 Like

Or you can create a formula field that calculates if the date has been reached e.g. Date ≥ Today()
and then use an automation that triggers when this field becomes true.