I'm trying to get a count of tapes pending by date. I'm using: select date(pending_date),count(*) from volumes where status='PENDING' - group by date(pending_date) but I get the error message: ANR2904E Unexpected SQL key word token - 'DATE'. pointing to the date in the group by clause.
Anyone know how to get a pending count by date? David