Query for current year and defined month and day

I need some help! Trying to recreate the following query in Wappler that works fine in SQL. I have been trying to get this to work for three days so any assistance greatly appreciated.

SELECT * FROM visits WHERE dateArr > DATE_FORMAT(NOW() ,’%Y-08-01’)