3 Replies Latest reply on Aug 26, 2016 6:22 AM by elizabeth.gancas

    DateTime, Parameters, KPI


      Hi All-


      I'm looking to use the 'Late?' KPI to mark when an Employee punches in after the time indicated by the parameters.


      I'm currently using this calc (this is the closest I've come to solving my own problem)

      if datepart('minute', [In Punch]) > [Punch In Minute Limit] then 'Late'

      elseif datepart('hour', [In Punch]) > [Punch In Hour Limit] then 'Late'

      else 'Early'



      However, it is giving me 'late' results based on only the minute datepart.

      Example: Employee 110877 punched in at 5:38 am which is well before 8:30 am but is being counted as late.


      Thank you in advance for any help!