I have a table:
ID StartDate EndDate
12 10/01/2021 12/01/2021
12 19/01/2021 NaT
12 03/01/2021 13/01/2021
12 09/01/2021 NaT
12 10/01/2021 14/01/2021
I'm trying to remove the rows with StartDate <= 10/01/2021 and EndDate == NaT
And the removed rows should go into a new table.
I have tried the following code, but it doesn't work.
NewTable = Table(Table.StartDate <= "10/01/2021" && EndDate == NaT,:);
Also, how to remove the rows meeting these conditions from the original table?
Thanks!
Best Answer