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 the...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis 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
------------------------------
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
------------------------------
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
------------------------------
Current formula:
var date HireDate=[Hire Date];
Date(Year(Today()),Month($HireDate),Day($HireDate))
------------------------------
Brandy Nunes
------------------------------
- MarkShnier__YouTry 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
------------------------------
