I have to give my rudy badge back, I forgot the single quotes around the dates, Sometimes my brain is so lax, I screw up my own fate! sum(if(dueDate between 2001-12-01 and 2001-12-30, ageAmt, 0)) AS "+150" should be sum(if(dueDate between '2001-12-01' and '2001-12-30', ageAmt, 0)) AS "+150" Duh... Jay p.s. rudy, it is mysql...