How to Get the Daily Record Creation Count Using SOQL in Salesforce

1. Open the Developer Console.
2. Open the Query Editor tab.
3. Paste and execute the following SOQL query.

1

select day_only(createdDate), count(createdDate) from account group by day_only(createdDate) order by count(createdDate) desc limit 10

Change account to the name of any object you want to query before executing.

Reference

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