- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to get the row number of the most recent date in the date column of a data table?
I want to get the row number of the most recent date in the date column of a data table?
Trying the following for the Date column in my data table
colmax(Data Table( "myData" ):Date);
gives me a number which is much greater than the number of rows in my data table so not making sense. Any direction would be useful.
When it's too good to be true, it's neither
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get the row number of the most recent date in the date column of a data table?
Created:
Nov 8, 2023 12:13 PM
| Last Modified: Nov 8, 2023 9:16 AM
(1018 views)
| Posted in reply to message from Neo 11-08-2023
dt << get rows where (:date == col Maximum(:date))
Just Col Max gives you the max date (in seconds). Then compare the max with the individual values to find the matches.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to get the row number of the most recent date in the date column of a data table?
Created:
Nov 8, 2023 12:13 PM
| Last Modified: Nov 8, 2023 9:16 AM
(1019 views)
| Posted in reply to message from Neo 11-08-2023
dt << get rows where (:date == col Maximum(:date))
Just Col Max gives you the max date (in seconds). Then compare the max with the individual values to find the matches.