How to get Quarters in a year.

We need more details about your expected output

I have a list of deals which are created and have a field known as closing date while closing the deal.

When i closed a deal it should get reflected in other grid based on the quarter.

The quarters are divided based on Jan to mar, apr to jun, jul to aug, and oct to dec.

The grid should show case the deals  based on the quarter in current year.

Write a Decision rule or Multiple If statements. Use Month Function to get the month of CloseDate.

month(ri!closeDate)

mk0724 said:

The grid should show case the deals  based on the quarter in current year

What do you mean by this You want to Query it from Database based on quarter or You want to just manipulate Queried Data?

I have to query it from the database.

I have tried using multiple if's but it wasn't working out.

Is it Recordtype or CDT?? .If it's  recordtype i suggest you to use a custom record field. 

1.If it's a recordtype go with  Extract a Partial Date for creating a Custom record field and use this field in Queryrecordtype. More About Extract Partial Dates

2.If it's CDT You need to Manipulate data After Coming or you need to use between operator(Don't think it gives expected outputs).

3.instead of Multiple if's (Which  is ton work) Go for a decision rule which somewhat looks like this

Call the rule, for month value pass it using month() function

You can try this---

if(
or(
month(todate(ri!date)) = 1,
month(todate(ri!date)) = 2,
month(todate(ri!date)) = 3,
),
"Jan-Mar",
if(
or(
month(todate(ri!date)) = 4,
month(todate(ri!date)) = 5,
month(todate(ri!date)) = 6,
),
"Apr-June",
if(
or(
month(todate(ri!date)) = 7,
month(todate(ri!date)) = 8,
month(todate(ri!date)) = 9,
),
"July-Sep",
"Oct-Dec"
)
)
)

For improved readability. 

It is a recordtype

Then go for a Custom record field just like i suggested