Discussions

Expand all | Collapse all

Anniversary Date Formula

  • 1.  Anniversary Date Formula

    Posted 8 days ago
    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 8 days ago
    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
    ------------------------------