I'm selecting records (open PO) and assign a different column base on the due date to quntity that is due but I'm getting a syntax error when i run the query. see code below SELECT PRTNUM_10, CURDUE_10, DUEQTY_10, IF(CURDUE_10 BETWEEN CURDATE() AND DATEADD('D',30,CURDATE()),DUEQTY_10,0) AS NEXT30 //IF(CURDUE_10 BETWEEN DATEADD('D',31,CURDATE()) AND DATEADD('D',60,CURDATE()),DUEQTY_10,0) AS NEXT60, //IF(CURDUE_10 BETWEEN DATEADD('D',61,CURDATE()) AND DATEADD('D',90,CURDATE()),DUEQTY_10,0) AS NEXT90, //IF(CURDUE_10 BETWEEN ...