SQL Help

[David E Ehresman]

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