2 Replies Latest reply on May 12, 2017 8:40 AM by Jim Dehner

    10.1.1

    John Rithvik

      Hi

      Can anyone help me please.

       

      start date = 2016-04-11 15:44:36.000

      end date =  2016-04-16 01:28:57.000

       

      When i am using DATEDIFF('hour',start date,end date) it is giving me 212 hours but actual answer is 106. I got 106 when i am calculating in SQL SERVER.

      If i want days    DATEDIFF('day',start date,end date) it is giving me 10 days but the actual answer is 5 days.

       

      Thankyou

       

      Regards

      John