Comments
-
Here is another formula that should work quite fine. As days are compared with days, months with months and years with years this is more precise than the FLOOR method which will show a year less in specific cases based on the leap year adjustments: YEAR(CURRENT_DATE)-YEAR("Worker"."Employee Date Of Birth") - CASE WHEN…