Automation triggerted when due date occurs

[anhanh]

I have a problem when using Automation:

In Event Type, I chose: "Data Change" > "All Changes"

In Condition, I typed: "

OR(AND(
[Time until due] <= "-00:00:00",
[status]<>"Completed"
),
[status]="Overdue"
)

"

It only works if I change the [Due Date] manually that the column [status] is set to "Overdue". It can not automate run when the [Due Date] comes and meet the Condition above.

Can anyone help me? Thanks

[Joseph_Seddik]

Welcome to the community!

The bot is triggered on a data change. When the Date "comes" there's no change in the data so there's no trigger.

You might want to think about running the bot on a daily schedule instead.

[anhanh]

But I think the column [Time until due] is changed right? It is a virtual column calculated by = [Due date] - NOW() 

[anhanh]

Oh I see, the Virtual column is not applied in Automation, the link reference is here.