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.


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]))
| improve this answer | |
  • I have a similar calculation in another list, it works ... – Diego Hillesheim Nov 25 '13 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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