Help

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

Solved
Jump to Solution
752 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tarah_Kendall
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

3 Replies 3
Kamille_Parks
16 - Uranus
16 - Uranus

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
4 - Data Explorer
4 - Data Explorer

Perfect…it worked! Thanks!

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