How can I change data field (date type) to show only YEAR?
When I try to use FORMULA = YEAR(my_custom_date__c) it throws an error.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityHow can I change data field (date type) to show only YEAR?
When I try to use FORMULA = YEAR(my_custom_date__c) it throws an error.
If the return type of the formula field is Text:
In order to see only the Year of a Date Field you will need to convert it into text. See the following:
TEXT(YEAR(My_Custom_Date__c))
If the return type of the formula field is Number:
YEAR(My_Custom_Date__c)
Date
to Text
– Derek F
Aug 4 '16 at 20:05