Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Priyal, you can find a solution for fiscal year with detailed explanation in this article Fiscal Year