How to select rows with NaT values ?

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!

Answer 1

[Walter Roberson]

 NewTable = Table(Table.StartDate <= datetime(2021,01,10) & isnat(EndDate),:);

or if you are okay with removing all NaT including cases where the StartDate does not match that criteria, then

NewTable = rmmissing(Table)

[Namrata Goswami]

Thank you.