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


with cte as(
select *,row_number() over(partition by ID order by STR_TO_DATE(DATEADD, '%d/%m/%Y %H:%i:%s') desc) as row_num
from Invoice 
) select ID,DATEADD,STATUS
from cte
where row_num =1;


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