Expand all | Collapse all

Anniversary Date Formula

  • 1.  Anniversary Date Formula

    Posted 05-22-2020 17:42

    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!


  • 2.  RE: Anniversary Date Formula

    Posted 05-22-2020 17:48
    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