I am "bucketing" values by CloseDate by the following formula:
=if(MonthName(CloseDate) < MonthName(vTodayDate), 'Before ' & MonthName(Today()),
if(Year(CloseDate) > Year(Today()), Year(vTodayDate)+1 & '+',
MonthName(CloseDate)))
As of today, the results show:
"Before Mar 2014"
"2015+"
Mar 2014
Apr 2014
May 2014
Jun 2014
Jul 2014
....
I want to the "2015+" value to be at the end and I can't figure out how. I tried using the DUAL function, but couldn't make it work. Any suggestions?
Thanks, Dan
