Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
how to calculate Tenure dynamically (including for a historical date) — Cloud Customer Connect
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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