Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Here my fiscal calener is started from Sep-Aug and i don't have months i have periods that each period contains 28 days only.
how can i make Quarter,Period,Week without hard code i want to make it as dynamic calender because i can't work on each year for manually changing the calender.
Please find attached file for Fiscal year and for making periods.
Thanks in Advance plz help
Thanks,
Ashok.
Suggest me some way?
I depends on how it is defined... If the fiscal year always starts on the first Monday of September, and each Period is 28 days long, the following can be used as script:
Load *,
1 + Div(Date - FirstDayOfYear,28) as Period;
Load *,
WeekStart(YearStart(WeekStart(Date),0,9)-1,1,0) as FirstDayOfYear; //First Monday of year
Load
Date(MakeDate(2012,8,31)+RecNo()) as Date
Autogenerate 3000;
HIC
...and if the year start instead is on the Monday closest to Sept 1st, the following can be used:
Load *,
1 + Div(Date - FirstDayOfYear,28) as Period;
Load *,
WeekStart(4+YearStart(WeekStart(Date),0,9)-1) as FirstDayOfYear; //Monday closest to 9/1
HIC
Hi Henric,
Thanks for reply it's helpful to me.
Thanks,
Ashok.