Forum Discussion
MarkShnier__You
2 years agoQrew Legend
Here is an example of a formula Date Field which will calculate an employees Next anniversary of their hire date. You could just adapt it for your purposes
var date HireDate=[Hire Date];
var date Datetest = Date(Year(Today()),Month($HireDate),Day($HireDate));
IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var date HireDate=[Hire Date];
var date Datetest = Date(Year(Today()),Month($HireDate),Day($HireDate));
IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- KeithHendrick2 years agoQrew MemberWorked perfectly. Thanks!
------------------------------
Keith Hendrick
------------------------------