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?
Solved
Formula for returning another column's date in the current year?
Best answer by Kamille_Parks11
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.
+27The 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.
+27Perfect…it worked! Thanks!
Great, mark it as the solution to close this thread.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.