# Discussions

View Only

## Anniversary Date Formula

• #### 1.  Anniversary Date Formula

Posted 05-22-2020 17:42
Hi!

Looking for a Formula (or other option) to convert anniversary date to anniversary month/day with current year. I would like to set this up so that it's always assuming the current year and therefore can be used to trigger a reminder.

I know there's a lot of older posts asking a similar question. Hoping there's an up to date solve since some of them seem pretty hairy.

The logic would look something like this - I realize date field's don't work like this, but to help illustrate the question -

Month(A Date) + Day(A Date) + CurrentYear()

Thank You!

------------------------------
Chris
------------------------------

• #### 2.  RE: Anniversary Date Formula

Posted 05-22-2020 17:48
np
var date HireDate = [My hire date field];  // put your Hire Date field here

Date(Year(Today()), Month(\$HireDate), Day(\$HireDate))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

• #### 3.  RE: Anniversary Date Formula

Posted 02-09-2021 13:14
Mark,

I saw your response, but I am quite confused by the shorthand. I have a field called Hire Date, and I would like to calculate an Anniversary date to use for reminders and other things. I tried what you have written here, but I may need it spelled out a bit more please.

Thank you, Brandy

------------------------------
Brandy Nunes
------------------------------

• #### 4.  RE: Anniversary Date Formula

Posted 02-09-2021 14:26
This is the code.  The np was just short for "No Problem"

var date HireDate = [My hire date field];  // put your Hire Date field here

Date(Year(Today()), Month(\$HireDate), Day(\$HireDate))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

• #### 5.  RE: Anniversary Date Formula

Posted 24 days ago
How do I show the next anniversary date once the anniversary date has passed?

Current formula:
var date HireDate=[Hire Date];
Date(Year(Today()),Month(\$HireDate),Day(\$HireDate))

------------------------------
Brandy Nunes
------------------------------

• #### 6.  RE: Anniversary Date Formula

Posted 24 days ago
Try this

var date HireDate=[Hire Date];
var date Datetest = Date(Year(Today()),Month(\$HireDate),Day(\$HireDate));