Error!

MySQL Error: Incorrect DATE value: '2020/ 03/30'
SQL Statement: select count(*) as total_records from (SELECT 1 FROM contents JOIN content_types on contents.content_type_id = content_types.id WHERE content_type_id IN ('2487') and contents.published=1 and publish_date <= '2024-04-25 11:47' and date(publish_date) >= '2020/ 03/30' and date(publish_date) < '2020/ 03/31' and contents.magazine_id=8 ORDER BY publish_date desc ) as t