function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
VSK98VSK98 

Getting the Year based on the now in formula field but i got like this 2,015

I have used this formula

YEAR( TODAY() )

i got 2,015
 but i need 2015
please help me out
Best Answer chosen by VSK98
Aditya TopalliAditya Topalli
My best guess is that, you must have given the return type of the formula field as "Number". Change it to Text.

and then update the formula to 
TEXT(YEAR(TODAY()))

 

All Answers

Aditya TopalliAditya Topalli
My best guess is that, you must have given the return type of the formula field as "Number". Change it to Text.

and then update the formula to 
TEXT(YEAR(TODAY()))

 
This was selected as the best answer
VSK98VSK98
Hi Aditya,

Nice ...........It's working fine now.

Thanks
Siv