---
schema_version: "1"
id: bfc6ef6e326432eb91551da47bc29d6eeb785790340567f2e4c6054d01891baa
title: day_in_month(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-day-in-month.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-day-in-month.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 0df6cc8860b803c6d59b204d823be6ab733e96baf1b671926d0a66a0dce06a23
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# day_in_month(date)

Returns an integer representing the day of the month for a specific date.

```nolang
q = foreach q generate day_in_month('OrderDate') as "Day in Month";
```