SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
Trying to create calculated field for SPD workflow. There should be yearly reminder (I wanted to compare "Date workflow started" with this field..).
Tried to create Date field/Calculated field with this formula but no result(field is empty)
=DATE(Year([Today]),12,31)
Maybe somebody did the same before?
Calculated Columns are evaluated on item modification, not on viewing. So [Today] is not an allowed value.
However, you can use this formula to get the 12/31 of the upcoming year:
=DATE(Year([Modified]),12,31)
You could also use [Created] depending on what you're trying to achieve.
