14 Replies Latest reply: Oct 7, 2015 11:27 AM by Manish Kachhia RSS

    HOW TO GET LATEST RECORD BASED ON TIMESTAMP

    reddy r

      Hi all

      I have a requirement of fetching the Customer_ID with the latest time stamp, what ever being the ITEM he had purchased.

      Header 1Header 2Header 3
      IDITEMTIME_STAMP
      123BOOKS8/18/2015 13:11
      123PEN8/18/2015 13:58
      123PENCIL8/19/2015 15:55
      999PEN7/17/2013 16:44
      777BOOKS7/27/2015 19:25
      777PENCIL7/29/2015 12:01
      777BOOKS7/29/2015 12:01

       

      I HAVE TO DISPLAY THE RECORD BASED ON LATEST TIMESTAMP IN A STRAIGHT TABLE.

       

      please can any one help...!!!

       

      Thanks in Advance