Select latest timestamp (String)

View Original Published Thread

Level V

Created: Sep 1, 2022 02:15 AM | Last Modified: Jun 10, 2023 4:53 PM 773 views

Hi all,

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

Sample Data:

Expected Output:

1 REPLY 1

Super User

Sep 1, 2022 03:30 AM (765 views) | Posted in reply to message from UserID16644 09-01-2022

Convert the time to Numeric (Datenum) and then use

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

-Jarmo

Re: Select latest timestamp (String)