Skip to main content
Question

Anniversary Date Formula

  • May 22, 2020
  • 0 replies
  • 59 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------