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'
