Good morning,
I have a data table with a date column in the following format "d/m/ah:m", I create a new date column from the previous column with now the following format "d/m/y". I would like to remove duplicates when the days are the same!
However when I remove duplicates from the new date column, it does not find any duplicates because even if the days, months and years are the same from one row to the next, JMP does not recognize the rows as duplicate rows.
There must be a problem with the notions of minutes, seconds etc.
How to get around this problem please?
