Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
how to calculate Tenure dynamically (including for a historical date)
Abhishek Bagh
Rank 4 - Community Specialist
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):
0