Determining the "new" year from a pre-determined date

[ptopkis]

For a project, I need to determine what year training was completed. However, the year starts on May 11th instead of on a quarter or year. 

In Excel it is simple as IF(Date_Completed>Date_Year_Started, Year_Started, "").  

Example: IF(2017-06-01>2017-05-11, 2017, ""). The dates could be the numeric version instead of the actual dates.

I tried using Formula to build the IF statement (using Alteryx IF statement) and kept getting malformed IF statement errors.

So any ideas on how to do this?

Thank you

[nick_ceneviva · Accepted solution]

The Alteryx equivalent of the if statement that you use in Excel would be the following if your dates are formatted as DateTime

IF DateTimeDiff([Date_Completed], [Date_Year_Started],"days")>0 THEN [Year_Started] ELSE "" ENDIF

[ptopkis]

That work. Thanks!