---
schema_version: "1"
id: 9ff2107920c6c206649e0ab87a86e317fa30b91639b3986baa831f2c3026d00b
title: month_days(date)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-month-days.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-month-days.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8edd712f30bfaafbac3261d093f7edde94eacab2c11cc8782d8faae52e40cd89
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# month_days(date)

Returns the number of days in the month for a specific date.

```nolang
q = foreach q generate month_days(BillDate) as "Days in Billing Month";
```