+ Start a Discussion
Karthik B.ax1475Karthik B.ax1475 

Display Fiscal Quarter based on date

Hi Techies,

       We have a requirement for populating Fiscal Quarter when date is selected. Our Fiscal Year Starts In month starts from April Flowing are our accounting periods

• April - June-Q1

• July-Sep-Q2

• Oct-Dec-Q3

• Jan- Mar-Q4

 

Let say When Date= 20/12/2012 based on month it should display Q3

15/6/2013 it should display as Q1

 

Can you please help me to create this.

Thanks,

Karthik

jd123jd123

Hi 

 

try this code replace with your date field

 

IF( month(Date1__c)<=3 , 'Q4',if(month(Date1__c)>3 && month(Date1__c)<=6,'Q1',if(month(Date1__c)>6 && month(Date1__c)<=9,'Q2',if(month(Date1__c)>9 && month(Date1__c)<=12,'Q3',null))))