Skip to main content
Currently, we are using the standard SFDC calendar year.  Because the company was acquired in the middle of our 2012 Q1, and the new company is using a custom fiscal year, I now need to enable custom fiscal periods in our SFDC instance.  For summary reporting purposes, I need a formula that will assign the appropriate custom quarterly fiscal period label for the following date ranges:

 

1. January 1, 2011 -  December 2011 (and any previous year) must be represented by the standard calendar year (Quarter X CY20XX)

 

2. January 1, 2012 - February 22, 2012, as Quarter 1 FY2012 (this is the tricky one for me  because that date range represents our entire FY2012)

 

3. February 23, 2012 - January 31, 2013, as Quarter X FY2013 (another tricky one because the year is short)

 

4. February 1, 2013 - Janurary 31, 2014, (and all subsequent years) as FY format listed above

 

I'm lost at sea whe it comes to date formulas.  Some one please throw me a floatation device!  Thanks!!!  :-)
3 respuestas
  1. 5 abr 2012, 18:26
    For now, the formula should be based on the opportunity close date.

     

    1/1/2012 - 2/22/2012 is our entire 2012 period (as Comany A) because of the aquisition.  After the acquisition, I need to run reports that show all opportunities that closed after 2/23/2012.

     

    Keep in mind, next year's (and all subsequent years) FY will run the full year (2/1/2013 - 1/31/2014)

     

    For now, the formula should be based on the opportunity close date. 1/1/2012 - 2/22/2012 is our entire 2012 period (as Comany A) because of the aquisition.