---
schema_version: "1"
id: 6794b734e7cb7956f4e6110536005b48dd92d43e90a9476c97fe3298ece7bf39
title: Day in the Week, Month, Quarter, or Year
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-saql-functions-dayinweek.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-dayinweek.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 5f6ef442be62059a5d17a7f623f524c8d47058ac086dd9595b28d0b3ad94f0a9
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# Day in the Week, Month, Quarter, or Year

Returns the day in the specified time period for a given date. These functions answer questions like "do we close more deals at the beginning or end of a quarter?".

## Example

Suppose that you want to see on which day of the week most deals are closed. Use `day_in_week(date)`.

```nolang
q = load "Data";

q = foreach q generate day_in_week(toDate('CloseDate_sec_epoch')) as 'Day In Week Closed';

q = group q by 'Day In Week Closed';
q = foreach q generate 'Day In Week Closed' as 'Day In Week Closed', count() as 'count';
q = order q by 'count' desc;
```

The resulting data displays the number of opportunities closed, grouped by the day of the week that the opportunities were closed on.

![Diagram showing number of close opps, grouped by day of the week they were closed.](https://developer.salesforce.com/media/bi_dev_guide_saql/bi_saql_date_dayInWeek.png)

It looks like most opportunities are closed on Thursday (day 5).

## day_in_week(date)

Returns an integer representing the day of the week for a specific date, where 1 = Sunday, 2 = Monday, etc.

```nolang
q = foreach q generate day_in_week(toDate('CloseDate_sec_epoch')) as 'Day In Week Closed';
```

## 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(toDate('CloseDate_sec_epoch')) as 'Day in Month Closed';
```

## day_in_quarter(date)

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

```nolang
q = foreach q generate day_in_quarter(toDate('CloseDate_sec_epoch')) as 'Day in Quarter Closed';
```

## day_in_year(date)

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

```nolang
q = foreach q generate day_in_year(toDate('CloseDate_sec_epoch')) as 'Day in Year Closed';
```