+ Start a Discussion

SOQL Query Month Wise

I have a requirement to find no of records created monthy,

the input here is the date range, start date and the end date .(start o the month)

My question is how to query between these dates to get the monthly avarage of a particular field and the count no of records created monthly.

any help, code samples would be appriciated.

Starz26
In Aggregate Query

Select Count(ID), CALENDAR_MONTH(StartDate)start From XXXXX Group By start

Need an account? Sign Up

Have an account? Sign In