Forum Discussion

mrp614's avatar
mrp614
New Member
4 years ago
Solved

Creating financial year column - How to make this code shorter and efficient?

Following code will work fine but will only cover the period from April 2019 to March 2025, is there a way to automate this code so that it generates FY as required based on the date clolumn?    F...
  • PaulOlding's avatar
    4 years ago

    Hi mrp614 

    This is a bit more compact

     

    IF( [Month]>=4), [Year] + 1, [Year] )