4 Replies Latest reply: Jun 25, 2016 11:20 AM by gaurav gopale RSS

    difference between two dates (in Days or Hrs)

    gaurav gopale
      IDAmtDateFlag
      110001/01/2016ORD
      220002/01/2016ORD
      110010/01/2016DEL
      220011/01/2016DEL

      I have the above table

       

      i want the difference between dates

       

      like Order Date (ORD) - Delivered Date(DEL)  in Days or Hrs

       

       

      How can i get the Difference?

       

       

      Can anyone help me ?

       

       

       

      thanks in advance