what's wrong with the following?

select Sum(Quantity) AS Quant from table1 group by Format(MGA00_DATE,"#")

Format(MGAOO_DATE, "m/d/yy")

not Format(MGAOO_DATE,"#")
# is for numbers





> what's wrong with the following?

> select Sum(Quantity) AS Quant from table1 group by Format(MGA00_DATE,"#")