Change start of quarter

[67peshawar294]

Our corporate year begins Dec 1 of each year. Is there a way to change the quarter start date ?

 

[MichaelRed]

AFAIK, the short answer is "No". However the question arises often, as almost no corporations actually have their calenaders synched to the sandard. The usual workaround is a bit of a tedious chore, but is very straight forward. When reporting by (Company) quarters, all the info is in aggregate format, so just do an offset of -1 month to all of the dates prior to the aggregation, as in:

AggDt = DateAdd("m", -1, RealDate)

or, in the query/alais form

AggDt: DateAdd("m", -1, RealDate)

but, alas alack and awry you usually need to do it numerous time and places.


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[67peshawar294]

I was afraid that was the answer...
Thanks Michael.
Jim