Weeks / Quarters

[David Tunstall]

Please Help.

Our business data runs from April to April. Is there
anyway that I can make 1st April week 1 - 31st March Week
52. We do reports quarterly but obviously when I produce
say a pivot chart, Quarter 1 shows Jan, Feb, Mar and I
need it to be Apr, May, Jun and so on.

Hope this makes sense

Thanks
David

 

[Michel Walsh]

Hi,


Compute the quarter like:

BusinessQuarter: DatePart("q", DateAdd("m", -3, myDate) )


Hoping it may help,
Vanderghast, Access MVP