Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Solved
Jump to Solution
281 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.

Perfect…it worked! Thanks!

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