
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 answers

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)