You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
1
Views
0
Comments
in General Transactional Reporting (OTBI)

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!