In our project, we have this Date-Key (which is a TEXT FIELD) in which we input dates with the ff. format:
Now in our custom object, we also have a formula(text) field that will retrieve the YEAR from the text field above.
The formula that I created is (I still don't know how to get the Year):
TEXT( DATEVALUE(Date_Key__c) )
I was hoping it would work but I only get #Error! in my Formula field.
Date_Key__c = 19-1-2016
formula(text) = #Error!
I was hoping that I would get 19-1-2016 and from their also retrieve the year which is 2016.
Any help is appreciated. Thanks.