8 Replies Latest reply: Dec 20, 2016 7:31 AM by Sunny Talwar RSS

    Max : Difference between 2 dates

    nayan lalla

      Hi

       

      I want to create a text box that shows the order number that has the most days between order date and receipt date.  Also I require another text box to show the value as well.  So referring to the table below,  The one text box should display "ORD005" and another to display "38".

       

      Thanking you in advance.

       

      Kind regards

      Nayan

       

       

      Order NumberOrder DateReceipt DateDays
      ORD00105-Jan-1625-Jan-1620
      ORD00218-Jan-1623-Jan-165
      ORD00327-Feb-1607-Mar-169
      ORD00403-Mar-1609-Mar-166
      ORD00508-Mar-1615-Apr-1638
      ORD00609-Apr-1623-Apr-1614
      ORD00705-May-1614-May-169
      ORD00825-May-1626-May-161
      ORD00914-Jun-1603-Jul-1619
      ORD01021-Jul-1628-Jul-167
      ORD01109-Aug-1629-Aug-1620
      ORD01222-Sep-1601-Oct-169