AnsweredAssumed Answered

date_field year equal to current year

Question asked by ERIKCHAN on Jan 29, 2009
Latest reply on Jan 29, 2009 by ERIKCHAN

Title

date_field year equal to current year

Post

I have a field store date call date_field. The date_field format is yyyy/mm/dd. I want to know how to calculate date_field year equal to current year.

I know that I can use YEAR(date_field) to get year.
But when I write a script in edit script window.
I choose the date_field.
Then how can I input the formula.

I tried to input
YEAR(date_field) ; Year(GET(CurrentDate))
in Calculated Result: Specify window.

But that have error message
"An operator (e.g. +, -, ", ...( is expected here.)"

How can I do?







Outcomes