Hi all,
I have a requirement of dividing 12 months in current year into 4 quarters.
Can anyone help me with it?
Discussion posts and replies are publicly visible
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)
Divya 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.
It is a recordtype
Then go for a Custom record field just like i suggested