How to calculate Fiscal Month
I have a requirement to calculate the Month and based on that Populate the target element.
1)If the Store open date is Future Date or Blank date than it is a new Store.
2)If the Store Open Date is falling in the first Monday or other Monday than it is comp Store till 53 week it is Comp and next week it will change to non comp.
Ex 3rd Aug is Monday so if the store is open on 3rd Aug or any day on or before 31st Aug it will come in Aug Fiscal Month and Calculation of Fiscal Month will start from Aug.
If Store is 1st of Sept but Monday fall in Aug ie 31st Aug so this store will again fall in Aug Fiscal Month.For Sept Fiscal Month to start,it will start from
7th of Sept 2015.Any Store open before 7th Sept,it will fall in Aug Fiscal month.
I want to generate 54 Record from 1 record saying 1-53 week is comp and last Record will carry status as non comp.