So when checking dates in SQL using 

<= CURDATE()

I was running into an issue with it not recognizing the EQUALS part. After some digging, it turns out when the database field is DATETIME, you need to use

DATE(your_date) <= DATE(NOW())

instead.