Need Help to convert Master calendar code to fiscal year calendar which is starting from April

[priyalvp24]

Hi All,

Below is my master calendar code.

Please help me to convert this code to Fiscal Year master calendar which is starting from the Month April.

temp_date:

Load

min(DocDate) as start_date,

Max(DocDate) as end_date

Resident All;

Let vstart_date=peek('start_date',0,temp_date);

Let vEnd_date=peek('end_date',0,temp_date);

Master_Calendar:

Load

date_id as DocDate,

num(Month(date_id)) as DocMonth,

Year(date_id) as DocYear;

Load

$(vstart_date)+IterNo()-1 as date_id

AutoGenerate 1 while($(vstart_date)+IterNo()-1<=$(vEnd_date));

Thanks,

Priyal.

[vunguyenq89]

Hi Priyal, you can find a solution for fiscal year with detailed explanation in this article Fiscal Year