Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Anniversary Date Formula

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
------------------------------

4 Replies

BrandyNunes1
Qrew Member
5 years ago
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
  Qrew Legend
  5 years ago
  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
  ------------------------------
  - BrandyNunes1
    Qrew Member
    5 years ago
    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
    ------------------------------