In Share Point 2010, I have a list of library books that are checked out. This list has a due date field.
This is what I want: When the books are past due a certain number of days from today's date, I want those items to be highlighted in red.
This is what I have tried. Created a calculated field, that calculates number of days from today's date till due date and shows as an integer. This calculated field only works if the list is updated. Meaning, if tomorrow I look at the list the calculated field does not reflect the calculation, unless I edit any item and save it.
My question is what mechanism should I use to have this calculated field updated everyday, with out any intervention.