Hide and Exclude dates column faster
Hello,I have a JMP table with 76K rows with a column named "sortDateColumn" that has dates in this format: 09/24/2020 11:29:25 AMin my code I have this line that takes 4 seconds to run minDate = "02/16/2021 12:23:09 AM";is there a faster way to run this line? since doing this a few times slows ...
dt << Select where( Column( sortDateColumn )[] <= Informat( minDate, "MDYHMS" ) ) << Hide and Exclude();
atlas100