Fiscal Quarters

M

Mike S.

Microsoft, in its knowledge base, has provided functions
for calculating fiscal years and fiscal months which may
vary by the beginning month and day of a fiscal year.
Would anyone know how to adapt the functions in order to
calculate a fiscal quarter?
 
A

Allen Browne

The fiscal quarter of the field MyDate would be:
DatePart("q", DateAdd("m", 6, [MyDate]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

End of Quarter Based on Fiscal Year 2
How do I expand a funtion's maximum character length? eg CUBESET 2
Dmin and Dmax With Criteria 3
Complicated Date Calculation needed 5
Get fiscal year to show in a report 4
Unsolvable 1
Grouping dates into Fiscal Yrs/Qtrs/Months 1
Median Calculation, Dates, & Group By 1

Top