Add a Year to a Date and return the new Year

Louie

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'

GrantSmith

Hi @Louie you can refer to my answer in your other post: https://dojo.domo.com/main/discussion/57293/adding-1-year-to-a-date-and-returning-the-new-year#latest