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
SubratSubrat 

I want to display current year along with previous year in my pickilist value by using formulafield.Currently I am using the "TEXT(YEAR(TODAY())) " formula field , but I want such a formula to display current & previous year

I want to display current year along with previous year in my pickilist value by using formulafield.Currently I am using the  "TEXT(YEAR(TODAY())) " formula field , but I want  a formula to display current & previous year ,any help ?
Oshin AgrawalOshin Agrawal
Hi Subrat,

You can write your formula like 
TEXT(YEAR(Date_field) + ' & ' + TEXT(YEAR(Date_field) - 1) 
this will give you  current year along with previous year.

Thank you
SubratSubrat
HI Oshin,

Thanks for your reply,but it is not working.