Formula Help

You can use a formula numeric field to calculate the days overdue, [Late]:

If(
ToDays([Due Date] - Today())>0,0,
Abs(ToDays([Due Date] - Today())))

Then you can set up a notification to fire when [Late] is greater than 0.

If you are wanting to automate this then you will have to have a table connection or sync in order to set up a refresh schedule.

I have something like this setup now and what i would like to capture is the history of lates... sorry, i dont think i spelled that out very well in my description.

thanks, 

You can create a Late History table and use an automation to copy the records to that table that are late.

This is the way i have it setup and it does not seem to be working properly. i assumed it was because the late status is triggered through a formula and within the automation it states to "trigger" when a user makes a change. 

If i go in and change the dates manually to drive a "Late" status, it will populate the other table as it is intended but it does not work on its own.

to work this way i need a formula correct? or maybe i have something else that is not setup correctly?

I see now. sorry i misunderstood... i had the automation triggered on a change as opposed to a schedule like you mentioned. thanks for your help. it should work now.