Add "CreatedDate" to an hour entry | Community
Skip to main content
ChrisBudgen
Level 5
March 27, 2019
New

Add "CreatedDate" to an hour entry

  • March 27, 2019
  • 0 replies
  • 234 views

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