Oracle Transactional Business Intelligence

Products Banner

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

Question
60
Views
0
Comments

Summary:

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):

Tagged: