cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
UserID16644
Level V

Select latest timestamp (String)

Hi all,

How can I select the rows with the same ID and code values but with the latest timestamp?

Sample Data:

UserID16644_0-1662012814397.png
Expected Output:

UserID16644_1-1662012863612.png

 

 

1 REPLY 1
jthi
Super User

Re: Select latest timestamp (String)

Convert the time to Numeric (Datenum) and then use

<< Select Where(:Time == Col Max(:Time, :ID))
-Jarmo