Checking if date column value is before/after a given date
I am using JMP pro 15. I have a column in my dataset "MRI_Date" which has values in the format MM/DD/YYYY. I would like to create a new formula column checking whether each value of MRI_Date is before or after the date 06/04/2014 and return "yes" if before and "no" if after. I tried this formula but it is not returning accurate results: If( :MRI_Date < "06/04/2014",
:before_6_4_14 = "yes",
:before_6...