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