You need to sign in to do that
Don't have an account?
sudhirn@merunetworks.com
Know Quater and Year based on a date
Hi,
I wrote below formula to get quater of based on the date I want to dispaly even the year of the quater please suggest me how to add the year in the formula field.
Thanks
Sudhir
I wrote below formula to get quater of based on the date I want to dispaly even the year of the quater please suggest me how to add the year in the formula field.
CASE(MONTH(DATEVALUE( Logo_Since__c ) ), 1, "Q1", 2, "Q1", 3, "Q1", 4, "Q2", 5, "Q2", 6, "Q2", 7, "Q3", 8, "Q3", 9, "Q3", 10,"Q4", 11,"Q4", 12,"Q4", "")
Thanks
Sudhir
Thanks
Sudhir