Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Add "CreatedDate" to an hour entry

Avatar

Level 6

27-03-2019

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