Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
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…