Fiscal week

[#1]

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!

[shaunsomai]

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