# COLUMN\_PERIOD

The **COLUMN\_PERIOD** function returns the start or end date for the specified time period.

|       |                                       |
| ----- | ------------------------------------- |
| START | Returns the start date of the period. |
| END   | Returns the end date of the period.   |

## 1. COLUMN\_PERIOD.START

## Syntax

```javascript
COLUMN_PERIOD.START
```

## Return value

Based on the granularity, this function returns the first day of the month for the corresponding month, quarter, or year.

## Example

```javascript
COLUMN_PERIOD.START
//Returns the start date of the month, quarter, or year
```

<div><figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FDpLJ5cAPc84PHwGWqZiW%2Fimage.png?alt=media&#x26;token=2e594117-8973-41f0-aa19-82401b5946c4" alt=""><figcaption><p>Month level</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FwUazyTyS4yJWElWqF6ZJ%2Fyear.png?alt=media&#x26;token=1bd1c46f-a846-4207-b5c4-d780c5afd74f" alt=""><figcaption><p>Year level</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FToMexKuqitBN7UGfiYlo%2FQuarter.png?alt=media&#x26;token=1a6bfb9e-078f-483d-b7b1-b373f758f298" alt=""><figcaption><p>Quarter level</p></figcaption></figure></div>

## 2. COLUMN\_PERIOD.END

## Syntax

```javascript
COLUMN_PERIOD.END
```

## Return value

Returns the last day of the month for the corresponding month, quarter, or year, depending on the granularity.

## Example

```javascript
COLUMN_PERIOD.END
//Returns the end date for the month, quarter, or year
```

<div><figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F1FzH6qBJE4yG4uaYqP9r%2Fimage.png?alt=media&#x26;token=c1c3877c-abc1-46b8-9ba8-24e2d42976ee" alt=""><figcaption><p>Year level</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F9zC58cSGcMspH4HXm3H6%2FQuarter.png?alt=media&#x26;token=0993d0ff-0ae1-47fa-9550-6f3a4fcf24b4" alt=""><figcaption><p>Quarter level</p></figcaption></figure> <figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F7K17fB4OWhdUeGqkegsG%2Fmonth.png?alt=media&#x26;token=9e181e67-b110-4beb-83cc-100da89f959b" alt=""><figcaption><p>Month level</p></figcaption></figure></div>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/formula-syntax/time-intelligence-functions/column_period.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
