Is there a way to group by the date portion of a datetime field in SOQL

Question

select day_only(createdDate) createdonDate, count(createdDate) numCreated from account group by day_only(createdDate) order by day_only(createdDate) desc

this soql return result count base on day. but i want result count base on month.any way to achieve this soql.

score 2 · Answer 1 · answered May 21 '13 at 05:20

2

Use CALENDAR_MONTH function:

select CALENDAR_MONTH (createdDate) createdonDate, count(ID) numCreated from account group by CALENDAR_MONTH (createdDate) order by CALENDAR_MONTH (createdDate) desc

answered May 21 '13 at 05:20

Shimshon Korits

1,189
6
10

Is there a way to group by the date portion of a datetime field in SOQL

1 Answers1