Month order starting April

[#1]

Hey guys I am using a fiscal calendar where I want my months displaying as beginning from April instead of Jan.

I've used =match(MONTH,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar') in the sort order.

Now although it works initially the sort order screws up as soon as you make a selection or filter on any particular dates.

Any ideas please ?

[buzzy996]

try this,if u have master calendar script "SET vFiscalOffset = 6;" just replace 6 with 4 and see?

[maxgro]

i think using dual and sort numeric

tmp:

load

  date(makedate(2015) + rowno() -1) as date

AutoGenerate 365;

cal:

load

  dual(month(date), Mod(month(date)-4, 12)+1) as month,

  year(date) as year,

  date

Resident tmp;

drop Table tmp;

[MarcoWedel]

Hi,

some ressources regarding this topic:

• Re: Fiscal calendarby its.anandrjs‌
• Fiscal Yearby hic
• Fiscal and Standard Calendar generationby jagan‌
• Re: Fiscal Calendar Problem‌ by jpe‌
• Re: Create fiscal calendarby rwunderlich‌

hope this helps

regards

Marco

[#5]

Sorry guys not having a huge amount of joy with this.

My script is as follows :

Date:
LOAD
$(vDateField)
,Month($(vDateField)) as MONTH
,MonthName($(vDateField)) as MONTH_YEAR
,Year($(vDateField)) as YEAR
,'Q'& Ceil(Month($(vDateField))/3) as QUARTER
,Year($(vDateField)) &'-Q'& Ceil(Month($(vDateField)) / 3) as QUARTER_YEAR

////////// Fiscal Year: Apr-Mar
     ,Year(AddMonths($(vDateField), +3)) as FISCAL_YEAR

,MonthName(AddMonths($(vDateField), -3)) as FISCAL_MONTH_YEAR
,'Q'& Ceil(Month(AddMonths($(vDateField), -3)) / 3) as FISCAL_QUARTER

FROM SOURCE