MySQL 5.7

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

create table table1 (Report_Received varchar(20))
insert into table1 values ('8/7/2019 11:39'),('6/18/2019 10:25')
SELECT Report_Received,
    DAY(STR_TO_DATE(Report_received, '%c/%e/%Y')) < 10 AS Compliance_Reporting
FROM table1


Report_Received
Compliance_Reporting


8/7/2019 11:39
1

6/18/2019 10:25
0