using dates Part 2

[daisy]

Karl was great in helping me get to this point with dates, now I'm wondering
if we can take it 1 step further?

For Activity Dates prior to 2/1/2007 they are using a normal reporting year
and the formulas below take care of Activity dates >2/1/2007?

So for example prior to 2/1/2007
1/1/2006 would have a B_Qtr of 2006-1


1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q")
2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate]))
3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q")