# 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://a.sfdcstatic.com/developer-website/sfdocs/analytics/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';
```