How to obtain the Fiscal Year when it starts October 1st. ?

[Marcegon]

Hi, I am trying to obtain the fiscal year with the rule below but I am getting some errors.  It is working for some rows but not for others.  What is wrong?  Any help would be appreciated.  

1) If DateTimeMonth([Start_Date_Out])>9 THEN DateTimeYear([Start_Date_Out])+1 ELSE DateTimeYear([Start Date]) ENDIF

2) IF [Fiscal Year]="2021" THEN "FY21" ELSEIF [Fiscal Year]="2022" THEN "FY22" ELSE "ERROR" ENDIF

My CSV file show the start date as 2021-10-01T09:00:00, so I configure the date as indicated below.  I tried yyyy-MM-ddTHH:mm:ss as well

[Amol_Telore · Accepted solution]

Hey @Marcegon 

In your formula, you have used Start_Date instead of Start_Date_Out at ELSE case scenario. Below is the updated formula.

New Formula :

If DateTimeMonth([Start_Date_Out])>9 THEN DateTimeYear([Start_Date_Out])+1 ELSE DateTimeYear([Start_Date_Out]) ENDIF

It will resolve your issue. Hope it helps.

Regards,

Amol Telore