Prev: turning off warnings in 2007
Next: This query is typed incorrectly or is too complex to be evalua
From: daisy on 26 Mar 2010 13:18
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")

--
Thank you in advance!!!!
 | 
Pages: 1
Prev: turning off warnings in 2007
Next: This query is typed incorrectly or is too complex to be evalua