Redefine week and month

[pkpandey]

Hi All

The week should be like 1,2,3,4 and this four weeks make a period say 1 again week 1,2,3,4 and make a period 2 and so on for a financial year (as given in the following chart). We have 4-5 years of data in the model.

Sun	Mon	Tue	Wed	Thu	Fri	Sat	JCWEEK	JCMONTH
29/03/2015	30/03/2015	31/03/2015	01/04/2015	02/04/2015	03/04/2015	04/04/2015	1	1
05/04/2015	06/04/2015	07/04/2015	08/04/2015	09/04/2015	10/04/2015	11/04/2015	2	1
12/04/2015	13/04/2015	14/04/2015	15/04/2015	16/04/2015	17/04/2015	18/04/2015	3	1
19/04/2015	20/04/2015	21/04/2015	22/04/2015	23/04/2015	24/04/2015	25/04/2015	4	1
26/04/2015	27/04/2015	28/04/2015	29/04/2015	30/04/2015	01/05/2015	02/05/2015	1	2