Need your help here. I'm building a calendar to show the Due Dates of my tasks by month. My query is this:

SELECT Owner.Name, OwnerId, id, Subject, ActivityDate, Status  
FROM task  
WHERE CALENDAR_MONTH(ActivityDate) = :month_d  
AND CALENDAR_YEAR(ActivityDate) = :year_d

But it gives me the error:

Error: field ActivityDate does not support date function CALENDAR_MONTH

Any idea how to do this?

1 Answer 1


The "Due Date" field on Task or Event can not be used with those Date Functions. There is an idea on the ideaExchange to support it.

The last comment in the idea has a suggestion for a workaround, which involves adding another date field to the Task and keeping it in sync with the Due Date field.

  • 1
    Yes, i already had read that to. I was just trying to find a workaround, and you helped. Thanks!
    – danielpm
    Oct 31, 2014 at 12:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .