quarterly calculation

[jamo]

I have this code in my query

Quarter: DatePart("q",[Date Paid])

that quartely. My financial year is July to June how do I ammend this code to reflect my financial year so that my first quarter will be july?

[JoeM]

Try:

Quarter: DatePart("q",DateAdd("m",6,[Date Paid]))

[jamo]

Thanks it works but my headings still read jan, feb, march for the first quarter instead of july aug september

[orange]

How are you identifying your headings now?
You have to adjust for the offset of fiscal year (6 months).

Sounds like where you normally have quarter 1 (months 1,2,3) you have to add 6 (7,8,9) Fiscal qtr months.

[JoeM]

Thanks it works but my headings still read jan, feb, march for the first quarter instead of july aug september

Headings??? You didn't mention anything about headings.
Are they the result of some formula? If so, what is the formula?

[jamo]

This is the code

MonthOfQuarter: (Month([Date Paid]) Mod 6)

it gives the month of the quarter

[JoeM]

MonthOfQuarter: (Month([Date Paid]) Mod 6)

I really don't understand what you are trying to do with this. This will just return a number from 0-5.

Regardless of which quarter you are in, if you are just trying to extract the month name from a date, you just need the MONTH function, and nothing else.
What exactly are you trying to do?
Maybe if you work us through a simple example, it will make more sense.

[jamo]

thanks fixed, just needed to be patient