https://community.jmp.com/t5/Discussions/How-to-get-the-row-number-of-the-most-recent-date-in-the-date/m-p/695755#M88088 <P>I want to get&nbsp; the row number of the most recent date in the date column of a data table?&nbsp;</P><P>&nbsp;</P><P>Trying the following for the Date column in my data table</P><PRE><CODE class=" language-jsl">colmax(Data Table( "myData" ):Date);</CODE></PRE><P>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.&nbsp;</P> Wed, 08 Nov 2023 16:52:32 GMT Neo 2023-11-08T16:52:32Z https://community.jmp.com/t5/Discussions/How-to-get-the-row-number-of-the-most-recent-date-in-the-date/m-p/695755#M88088 <P>I want to get&nbsp; the row number of the most recent date in the date column of a data table?&nbsp;</P><P>&nbsp;</P><P>Trying the following for the Date column in my data table</P><PRE><CODE class=" language-jsl">colmax(Data Table( "myData" ):Date);</CODE></PRE><P>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.&nbsp;</P> Wed, 08 Nov 2023 16:52:32 GMT https://community.jmp.com/t5/Discussions/How-to-get-the-row-number-of-the-most-recent-date-in-the-date/m-p/695755#M88088 Neo 2023-11-08T16:52:32Z https://community.jmp.com/t5/Discussions/How-to-get-the-row-number-of-the-most-recent-date-in-the-date/m-p/695765#M88090 <PRE><CODE class=" language-jsl">dt &lt;&lt; get rows where (:date == col Maximum(:date))</CODE></PRE><P>&nbsp;</P><P>Just Col Max&nbsp; gives you the max date (in seconds). Then compare the max with the individual values to find the matches.</P> Wed, 08 Nov 2023 17:16:47 GMT https://community.jmp.com/t5/Discussions/How-to-get-the-row-number-of-the-most-recent-date-in-the-date/m-p/695765#M88090 hogi 2023-11-08T17:16:47Z