Add a Year to a Date and return the new Year

Hi,

I am trying to return the year after a specific date, I tried the below but it is not returning what I anticipated

WHEN MONTH(`hireDate`)>=2 AND MONTH(`hireDate`)<=4 THEN CONCAT(YEAR(ADDDATE(`hireDate`,INTERVAL 1 Year)),' - Q1')


For example, if the hireDate was 02/01/2023, the return should be '2024 - Q1'

Comments