SELECT count(*)
FROM sales
WHERE created_at >='2021-02-01T00:00:00'
  --                        vv 21st of Feb
  AND created_at <='2025-02-21T00:00:00';

+----------+
| count(*) |
+----------+
| 24176    |
+----------+

SELECT count(*)
FROM sales
WHERE created_at >='2021-02-01T00:00:00'
  --                        vv 30th of Feb which doesn't exist
  AND created_at <='2025-02-30T00:00:00';

+----------+
| count(*) |
+----------+
|        0 |
+----------+

set forbid_invalid_date=1;