Discussions

 View Only
  • 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
    Your Quick Base Coach
    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
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Anniversary Date Formula

    Posted 05-20-2021 10:58
    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 05-20-2021 11:20
    Try this

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

    IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1)

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