https://community.jmp.com/t5/Discussions/Select-latest-timestamp-String/m-p/539361#M76033 <P>Hi all,</P><P>How can I select the rows with the same ID and code values but with the latest timestamp?</P><P>Sample Data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UserID16644_0-1662012814397.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45120i8FC9181BD6BCD5C3/image-size/medium?v=v2&amp;px=400" role="button" title="UserID16644_0-1662012814397.png" alt="UserID16644_0-1662012814397.png" /></span><BR />Expected Output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UserID16644_1-1662012863612.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45121iAC6A24A236335B8C/image-size/medium?v=v2&amp;px=400" role="button" title="UserID16644_1-1662012863612.png" alt="UserID16644_1-1662012863612.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 10 Jun 2023 23:53:44 GMT UserID16644 2023-06-10T23:53:44Z https://community.jmp.com/t5/Discussions/Select-latest-timestamp-String/m-p/539361#M76033 <P>Hi all,</P><P>How can I select the rows with the same ID and code values but with the latest timestamp?</P><P>Sample Data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UserID16644_0-1662012814397.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45120i8FC9181BD6BCD5C3/image-size/medium?v=v2&amp;px=400" role="button" title="UserID16644_0-1662012814397.png" alt="UserID16644_0-1662012814397.png" /></span><BR />Expected Output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UserID16644_1-1662012863612.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45121iAC6A24A236335B8C/image-size/medium?v=v2&amp;px=400" role="button" title="UserID16644_1-1662012863612.png" alt="UserID16644_1-1662012863612.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 10 Jun 2023 23:53:44 GMT https://community.jmp.com/t5/Discussions/Select-latest-timestamp-String/m-p/539361#M76033 UserID16644 2023-06-10T23:53:44Z https://community.jmp.com/t5/Discussions/Select-latest-timestamp-String/m-p/539378#M76035 <P>Convert the time to Numeric (Datenum) and then use </P> <PRE><CODE class=" language-jsl">&lt;&lt; Select Where(:Time == Col Max(:Time, :ID))</CODE></PRE> Thu, 01 Sep 2022 07:30:06 GMT https://community.jmp.com/t5/Discussions/Select-latest-timestamp-String/m-p/539378#M76035 jthi 2022-09-01T07:30:06Z