I have a YEAR(CloseDate) which required to be a number field type. And when I try to convert it to text to get rid of the 2,014 comma with something like this... TEXT(YEAR(CloseDate)) or this... YEAR(TEXT(CloseDate))

It states...

Formula result is data type (Text), incompatible with expected data type (Number). (Related field: Formula)

Please help.


So if understand, you created a formula field of type number to get the year of a Date field ? I think you have to change the type of the formula to text and use your first one


Good luck

  • Thanks Melmoussaoui, that did it. I should have tested the text but overlooked, I guess I was to close to it.
    – Miklr
    Feb 4 '14 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.