MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Invoice ( 
ID varchar(20),
DATEADD varchar(255),
STATUS varchar(2) );

insert into Invoice values 
('A0011','04/01/2018 11:58:31','N'),
('A0011','31/05/2019 10:02:36','N'),
('B0022','04/01/2018 11:58:31','N'),
('B0022','31/05/2019 10:02:36','N'),
('B0022','30/04/2020 19:44:36','N');
select * from Invoice;


ID
DATEADD
STATUS


A0011
04/01/2018 11:58:31
N

A0011
31/05/2019 10:02:36
N

B0022
04/01/2018 11:58:31
N

B0022
31/05/2019 10:02:36
N

B0022
30/04/2020 19:44:36
N


  SELECT ID,  DATEADD,status
  FROM Invoice in1 where (ID,STR_TO_DATE(DATEADD, '%d/%m/%Y %H:%i:%s')) in ( select ID,
                                                  MAX(STR_TO_DATE(DATEADD, '%d/%m/%Y %H:%i:%s'))
                                           from  Invoice
                                           GROUP BY ID )
 ;


ID
DATEADD
status


A0011
31/05/2019 10:02:36
N

B0022
30/04/2020 19:44:36
N

ID	DATEADD	STATUS
A0011	04/01/2018 11:58:31	N
A0011	31/05/2019 10:02:36	N
B0022	04/01/2018 11:58:31	N
B0022	31/05/2019 10:02:36	N
B0022	30/04/2020 19:44:36	N