I am trying to create a calculated field where I am trying to add Today date Column and 365 days. I think I applied wrong syntax. The text [Today Date]+365 shown as it is in column entry.
asked Oct 11, 2016 at 14:57
-
Please post your entire formula in text, not image. It looks like you've only closed the OR statement, but haven't finished the IF statement.– Erin LCommented Oct 11, 2016 at 16:10
-
1You have the ([Today date] + 365) enclosed in double quotes, which i believe is making it a string– Eric AlexanderCommented Oct 11, 2016 at 16:42
Add a comment
|
1 Answer
Try the Formula
=Today+365
or
=[Today]+365
in order to get the current date + a year
