Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Fiscal Year begins on 10/1 and I need to calc Week in my load script based on the fiscal year start date rather than Jan 1. Please advise.
Thanks!
Try something like this, this is when your FinYear starts on the 1 April
If
Week(MyDate) < Week( 1st April of the FinYear for MyDate)
Then
52 + (Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1
Else
IF
Month(MyDate=3)
Then
52 + (Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1
Else
(Week(MyDate) - Week( 1st April of the FinYear for MyDate)) +1
Shaun