Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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