In the statement below. I want to make the column heading be 'June' and would like to pull it from the current date. What I'm trying below is returning "Incorrect syntax near 'getdate()'
select ISNULL(sum(case when month(due_dt) <= month(getdate()) and year(due_dt) = year(getdate()) then ord_qty end),0) as CAST(getdate() as CHAR(3))
where item_no = '28185' and ord_type in ('FO','CO','MR')