Hi

I need to group records by month and year based on a timestamp (InDate in the example). Tried the following example but receive a "token unknown" error:

select
count(indate), indate, month(indate), year(indate)
from
baddebtorstatproc
where
(proccode in ('INVT' ,'CWEB'))
group by
indate, month(indate), year(indate)


I need to count how many records found for a specific month and year.

Any help greatly appreciated.


Morné

http://www.activesms.co.za?sponsor=270829284115


[Non-text portions of this message have been removed]