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]))
 
Top