Fiscal calendar beginning July 1

[#1]

Hi

I need to amend the following code which currently works out a standard calendar year to a fiscal calendar year which runs from 1st July to 30th June. Your input is appreciated.

,Month($(vCalendarDate)) as MONTH

,Year($(vCalendarDate)) as YEAR

,('Q'&Ceil(Month($(vCalendarDate))/3)) as QUARTER

Thanks

Sid.

[awhitfield]

Hi Sid,

check out the attached which contains a standard fiscal Calendar, you should be able to tweak it to fit!

[jonathandienst]

Something like this:

,Month($(vCalendarDate)) as MONTH

,Year($(vCalendarDate)) as YEAR

,('Q'&Ceil(Month($(vCalendarDate))/3)) as QUARTER

,Year(YearStart($(vCalendarDate), 7)) As FiscalYear

,Mod(Num(Month($(vCalendarDate))) + 5, 12) + 1 As FiscalPeriod

,'FQ' & Ceil((Mod(Num(Month($(vCalendarDate))) + 5, 12) + 1)/3) As FiscalQuarter

[#4]

Thanks Jonathon. That just adds 7 years onto each year rather than start a new year if it reaches the 7th month