Custom week Calculations

[Raju_6952]

Hi, I have a requirement in Qlik sense that I am calculating fiscal year from sep1st to 31st august. using below formulae

Yearname(Date,0,9) as Fiscal Year,similarly I also need to calculate custom weeknumber starting from september1st to 31st august.

exaample as follows 

week 1 - sep1st -sep07

week2-sep08-sep14

week3-sep15-sep27 and so on dynamically ..

Thanks in Advance,

Raju

[anat]

Right(WeekName(TempDate,0,-36),2) as NewWeek