Forum Discussion

ChrisFaye1's avatar
ChrisFaye1
Qrew Cadet
5 years ago

Anniversary Date Formula

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
------------------------------
  • 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
    ------------------------------
    • BrandyNunes1's avatar
      BrandyNunes1
      Qrew Member
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------