2 Replies Latest reply on Sep 8, 2016 9:48 AM by emma.villarreal

    DATEDIFF not giving me the right minutes

    emma.villarreal

      Hello everybody good morning, i am having an issue doing a Datediff

      I have the next table

      Captura de pantalla 2016-09-08 a la(s) 11.23.49 a.m..png

      and doing this

      DATEDIFF('minute',[Fecha de Compra] ,(if [Kpi]='prm:created_to_florist:orig'  THEN [End] END ))

       

      it sends 10,208 when the right answer is the difference between August 31 and September 1 which is like around 900 minutesl, why is this, I am attaching my workbook