ajetrumpet,
Thanks for the recommendation of DateAdd, I didn't have to worry about an iif statement since I wanted the first two quarters to group with the next calendar year. Here's what I came up with:
Code:
rmDate By Quarter: Format$(DateAdd("q",2,[tblReportingMatrix].[rmDate]),'\Qq')
& " " & Format$(DateAdd("q",-2,[tblReportingMatrix].[rmDate]),'yyyy')
& "-" & Format$(DateAdd("q",2,[tblReportingMatrix].[rmDate]),'yyyy')
This now gives me the correct result of:
'Q1 2011-2012' for a date of '7/12/2011' instead of 'Q3 2011'.
Thanks for your help.