How to change date field value to year? 8/4/2016 --> 2016

Question

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.

cmmoutes13 · Accepted Answer · 2016-08-05 11:50:51Z

5

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)

answered Aug 4 '16 at 19:56

cmmoutes13

9928 silver badges31 bronze badges

The Question asker will also have to change the type of their formula field from Date to Text – Derek F Aug 4 '16 at 20:05
Or use Number and remove TEXT(...). – Adrian Larson♦ Aug 4 '16 at 20:19
I edited my answer. Thank you @AdrianLarson and Derek – cmmoutes13 Aug 4 '16 at 20:49

add a comment |

1 Answer 1