I have a list of controller the assets the enterprise. In this list I have a column with the warranty date. A calculated column verifies if the date already expired. When I add or edit an item, everything works great.


When someone accesses the list view, information from the calculated field is not updated. I get no errors, and this works in other lists.

1 Answer 1


I think your problem is with using a calculated field to check against [Today]. The calculation is only run when the item is edited - not when the item is viewed. See http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/

What I would recommend is creating a calendar view for this list and changing your calculated column to something like:

=DATE(YEAR([Date last reviewed]),MONTH([Date last reviewed])+[months to expire in],DAY([Date last reviewed]))
  • I have a similar calculation in another list, it works ... Commented Nov 25, 2013 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.