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.
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.
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.