9 Replies Latest reply: Nov 1, 2014 2:51 AM by anbu cheliyan RSS

    Keeping only the Record that has the Max Create Date

    Jeremy Schmitt

      I want to left join a new table to a current table I have. My new table I am pulling from an existing Qvd, has multiple records for an account number. What is the easiest way, in my report, to only pull the record that is the max CreatedDate, for each unique account number? I need the status (3rd column) from that most recent record.

       

       

      Capture.JPG.jpg