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)


Maybe somebody did the same before?

1 Answer 1


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:


You could also use [Created] depending on what you're trying to achieve.

  • Thank You for response! I know, but in my case I need [Today], because next year it will show wrong information(in 2019 it will still be '2018-12-31').. Uff..
    – Gennady G
    Commented Feb 22, 2018 at 15:21

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.