APEX

I'm trying to create a calendar that will display the number of times a job ran each day. This is the SQL statement I'm using to build the calendar.

SELECT actual_completion_date, count(*)
FROM some_table
WHERE job_id = :P1_JOB_ID
GROUP BY actual_completion_date;

The calendar works except for that actual_completion_date is stored in the database as 'DD-MON-YYYY H24:MM:SS' so if a job ran 8 times on a day the calendar will have 8 1's displayed for that day instead of an 8. I tried to change the actual_completion_date to trunc(actual_completion_date), but when I run it in the application I get an HTTP page can't be displayed error and in the Apache error_log there is an ORA-00904 error ACTUAL_COMPLETION_DATE invalid identifier. I also tried to do to_date(to_char(actual_completion_date, 'DD-MON'YYYY')) and I still get an HTTP page error and the log file now has ORA-00920: invalid relational operator.

Can anyone please give me some help on getting this to display the calendar with the total count displayed for each date.