Formula: Color Coding and Dates
Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic inform...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this as a formula numeric field which should calculate the number of completed service years
var date HireDate = [Hire Date];
Year(Today())-Year($HireDate)
-
If(
Month(Today())<Month($HireDate)
or
(Month(Today())=Month($HireDate) and Day(Today())<Day($HireDate)),1,0)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var date HireDate = [Hire Date];
Year(Today())-Year($HireDate)
-
If(
Month(Today())<Month($HireDate)
or
(Month(Today())=Month($HireDate) and Day(Today())<Day($HireDate)),1,0)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------