Get Quater dates based on close date in opportunity

Hi,

Based on close date in opportunity I need to create a formula field to identify to which quater and year it belongs to QQYYYY format.

Please suggest me how to get this details.

Thanks
Sudhir

February 10, 2016
·
Answer
·
Like
0
·
Follow
1

SaiG
Assuming your Fiscal Year starts in Jan, you could try this logic:

CASE( MONTH(( CloseDate )),
1, "Q1"&RIGHT(TEXT(YEAR((CloseDate))), 4),
2, "Q1"&RIGHT(TEXT(YEAR((CloseDate))), 4),
3, "Q1"&RIGHT(TEXT(YEAR((CloseDate))), 4),
4, "Q2"&RIGHT(TEXT(YEAR((CloseDate))), 4),
5, "Q2"&RIGHT(TEXT(YEAR((CloseDate))), 4),
6, "Q2"&RIGHT(TEXT(YEAR((CloseDate))), 4),
7, "Q3"&RIGHT(TEXT(YEAR((CloseDate))), 4),
8, "Q3"&RIGHT(TEXT(YEAR((CloseDate))), 4),
9, "Q3"&RIGHT(TEXT(YEAR((CloseDate))), 4),
"Q4"&RIGHT(TEXT(YEAR((CloseDate))), 4))

February 10, 2016
·
Like
1
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Get Quater dates based on close date in opportunity

You need to sign in to do that.