Our goal is to promote same-day timesheeting, and in order to monitor this we have defined a KPI calles Timesheeting-Lag.
In order to measure this, we want to calculate the DATEDIFF between when an hour was created and when it occured so that we can monitor how big the timelag is for a user to put his time into WF.
Let’s say I’ve worked on Task ABC on the 20th of March, but I entered it into my timesheet on the 22nd of March:
- Date Created: 22.03.
- Date Occurred: 20.03.
- DATEDIFF: 2