Formula for returning another column's date in the current year?

[Tarah_Kendall]

I have a column with employee start dates, called “Start Dates”, and I have a column called “Anniversary Dates” where I need a formula to show the start dates in the current year 2022. What is the formula?

[Kamille_Parks · Accepted solution]

The formula could be something like:

IF(
   {Start Date}, 
   DATETIME_PARSE(
      YEAR(TODAY()) & DATETIME_FORMAT({Start Date}, "-MM-DD")
   )
)

^ check to see if there’s a date to format, then take the Year of “today” and prepend it to the Month and Day of the start date.

[Tarah_Kendall]

Perfect…it worked! Thanks!

[Kamille_Parks]

Great, mark it as the solution to close this thread.