Forum Discussion
RoxanneZiegler
7 years agoQrew Trainee
comes up with a bunch of errors when I add it to the formula. $mydate seems to be a big problem
A variable declaration must end with a semi-colon.
var date MyDate = [Start of Employment] Date];
Year(Today())-Year($MyDate DOB)
-
If(
Month(Today())<Month($MyDate DOB)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0)
A variable declaration must end with a semi-colon.
var date MyDate = [Start of Employment] Date];
Year(Today())-Year($MyDate DOB)
-
If(
Month(Today())<Month($MyDate DOB)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0)