Oracle Transactional Business Intelligence

Products Banner

how to calculate Tenure dynamically (including for a historical date)



I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date.

I am using a date prompt for the report where a user can input any historical date, now what I am wondering how do I revise my tenure calculation to be based on Date Input value & Enterprise Seniority Date instead of just based on current date & seniority date.

Can anyone suggest a work around this on how to manage this dynamically?

CAST(TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Enterprise Seniority Date", CURRENT_DATE) AS FLOAT)/365

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):