Skip to main content
Diavia Webster a posé une question dans #Sales And Marketing
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 réponses
  1. 5 avr. 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.