https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375285#M62512 <P>Hi there,&nbsp;</P><P>I new to JMP and was wondering if someone could help me a question.</P><P>I have multiple rows of data (that are dates) and I want to be able to another column which captures the earliest date from each row. Is there away to do that?</P><P>Thanks.&nbsp;</P> Sat, 10 Jun 2023 20:44:15 GMT Ash 2023-06-10T20:44:15Z https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375285#M62512 <P>Hi there,&nbsp;</P><P>I new to JMP and was wondering if someone could help me a question.</P><P>I have multiple rows of data (that are dates) and I want to be able to another column which captures the earliest date from each row. Is there away to do that?</P><P>Thanks.&nbsp;</P> Sat, 10 Jun 2023 20:44:15 GMT https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375285#M62512 Ash 2023-06-10T20:44:15Z https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375289#M62514 <P>The formula for the new column would be</P> <PRE><CODE class=" language-jsl">min( :Date1, :Date2, :Date3 );</CODE></PRE> Thu, 08 Apr 2021 20:35:45 GMT https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375289#M62514 txnelson 2021-04-08T20:35:45Z https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375294#M62515 <P>Thank you so much!</P> Thu, 08 Apr 2021 20:36:45 GMT https://community.jmp.com/t5/Discussions/How-to-make-a-formula-to-pick-out-the-minimum-date-from-a-row-of/m-p/375294#M62515 Ash 2021-04-08T20:36:45Z