---
schema_version: "1"
id: bd9e8c8f86ce0a7698d5e3d64a067970a0815ce50f6a0b5421cae456ae49e59d
title: Group By Date Part
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-date-group.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-date-group.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 79b24e83216dc6c05d55a60c72effc47b2bb95a1410d6b0452f0fb6ad5784a46
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# Group By Date Part

To group by date part, use the `GROUP BY` clause and the `EXTRACT()` function. Pass `EXTRACT()` the date parts to isolate.

```nolang
SELECT EXTRACT(YEAR FROM CloseDate) AS CloseDate_Year, EXTRACT(MONTH FROM CloseDate) AS CloseDate_Month, count(*) AS cnt
FROM "OpportunityFiscalEMTimezoned"
GROUP BY EXTRACT(YEAR FROM CloseDate), EXTRACT(MONTH FROM CloseDate)
LIMIT 10;
```

The results are grouped by year and month parts of the CloseDate field.

| CloseDate_Year | CloseDate_Month | cnt |
| -------------- | --------------- | --- |
| 2014           | 12              | 1   |
| 2015           | 1               | 3   |
| 2015           | 2               | 1   |
| 2015           | 3               | 2   |
| 2015           | 4               | 2   |
| 2015           | 5               | 2   |
| 2015           | 6               | 1   |
| 2015           | 8               | 1   |
| 2015           | 10              | 1   |
| 2015           | 11              | 1   |