2

Created a field with the formula Today + 2 days, checked the next day, the date is old, i.e. in which this column was created, I need the date to be updated every day, how to implement it?

2 Answers 2

2

If you create a Today column it needs to be updated. You can do that with either a timer job or by placing a jquery script on a page that is hit by the user. The script could call SPServices.SPUpdateMultipleListItems to do the update. Pass a CAML clause so that you only update the list items where the Today value needs to be updated, e.g. once per day.

1
  • I'm a testing your answer :))
    – Shrek
    Sep 4, 2017 at 12:05
3

Formulas in calculated columns are only recalculated when the item is saved. The value is static until it is saved again. So the value for [Today] will be the date the last time the item was updated and won't change again until the next time it is updated.

One option might be to write a PoweShell script to read and update every row in the list and run it on the scheduler every day.

1
  • I do not have access to the server, Powershell does not fit uniquely.
    – Shrek
    Sep 4, 2017 at 12:05

Your Answer

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

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