0

I need to create a calculated column that would need to show the years since a document was published. Notice that I'm not saying [Created]. The issue is that I have a document library where our office staff upload documents. One of the required columns called "Year Published" (Number). The calculated column would calculate the difference. I tried [Year Published] - Year([Today]), but that fails as the error message I get says... "Calculated columns cannot contain volatile functions like Today and Me".

Any suggestion here?

Improve this question

1 Answer 1

Reset to default
1

As a workaround, you could create a date and time column called Today with Today's date as default value. Then use following formula in the calculated column.

[Year Published] - Year([Today])

enter image description here

Improve this answer

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.