Skip to Content

Changing the Fiscal Year Definition

Hi there,

I have a date field BUSINESS_DATE in IDT. After exporting to webi, I used year(BUSINESS_DATE) which gives me results like 2017, 2018, 2019 etc. Apparently, dates like 21/01/18 are in the 2018 category.

I have a requirement that the fiscal year starts from April of an year till March end of next year and hence dates like 21/01/18 should come in 2017-18 category.

Can anyone help me on this, I have to implement the same requirement with a lot of dates.

Thanks in Advance..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 13, 2018 at 09:33 AM

    try this.

    =If(MonthNumberOfYear([Calendar Date]) InList (1;2;3)) Then Year([Calendar Date]) Else Year([Calendar Date])+1

    Add comment
    10|10000 characters needed characters exceeded

    • There is a slight change in the formula

      =If(MonthNumberOfYear([Calendar Date]) InList (1;2;3)) Then Year([Calendar Date])-1 Else Year([Calendar Date])

      Leaving this, working fine. Thanks for the solution.