Creating a 14-month time period

[burgersurfer]

Hi

I have a QV document in which the fiscal year is defined from June > May. All reporting is done off this FY, but managers now want to expand on this time period to include 2 previous months, making the reporting period from e.g. April 2011 > May 2012. This will therefore include data from FY2011 (the two months April and May 2011), and the twelve months from FY2012.

How do I define a 14-month "year" in QV?

My script currently creates the FY as follows:

TempDate AS CalendarDate,

If(Month(TempDate) > 5, Month(TempDate)-5, Month(TempDate)+7) as FinMonth,

.....

Thanks!

[#2]

Try this one:

TempDate AS CalendarDate,

If(Month(TempDate) > 3, Month(TempDate)-3, Month(TempDate)+11) as FinMonth