Query syntax for Date

1 
WHERE
	`po`.`status` not in ('Stopped', 'Closed')
	AND `po`.`docstatus` = 1
	AND IFNULL(`poi`.`received_qty`, 0) < IFNULL(`poi`.`qty`, 0)
	AND `poi`.`schedule_date` < Today

	GROUP BY `poi`.`name`

Please help me to complete this query. I need to check shcedule_date < today

2

Hi,
use like this,
WHERE
po.status not in (‘Stopped’, ‘Closed’)
AND po.docstatus = 1
AND IFNULL(poi.received_qty, 0) < IFNULL(poi.qty, 0)
AND poi.schedule_date < Today

GROUP BY poi.name
3

Replace “Today” with CURDATE()

4

Thank you