Expressing Years in Quarters

[#1]

Hi There,

I'm using the following expression to express months as quarters:

'Q' & Ceil(Month(Date(Date# (<MyDate> , 'YYYYMM'),'DD-MMM-YY'))/3) as Quarter

However, where I work, our Financial year begins in November, so Q1 is (Nov, Dec, Jan).

The expression above returns Q1 as the first three month of the calendar year (Jan, Feb, Mar).. Any tips on how I can modify this to return Q1 starting in Nov?

Thanks

John

[#2]

Thanks to all for the help with this It's really appreciated. your suggestions fixed my problems - I'm sure I'll have many more.... Many thanks again.

John