I have a custom field with date type. I want to use just the year from this date field for a calculation. I want to use to update a field value. I am unable to get only the year from the date field. I would like to get the year and subtract it by 10.
YEAR( finish_date__c) -> It gave an error
YEAR( DATE(finish_date__c) ) -> Did not work this way too.
Any idea how I can just get the year and use it in formula?