Built-in Functions → quarterEndDate

quarterEndDate() is a conversion function that returns the last date of the quarter for the given date or timestamp.

Signature

quarterEndDate(date_timestamp exp)

The following table illustrates the quarterEndDate() parameter:

Parameter	Description
date_timestamp exp	The `date` or `timestamp` value to determine the quarter end date from

Returns

date representing the end date of the quarter for the given date or timestamp.

Examples

Identify the last date of the current quarter for the given date, 08/17/2021.
```
quarterEndDate(
    date(
        "2021-08-17"
    )
)
```

Identify the last date of the current quarter for the given timestamp, 2021-07-20 03:09:11.
```
quarterEndDate(
timestamp(
"2021-05-20 03:09:11"
)
)
```

The following table illustrates the behavior of the quarterEndDate() conversion function:

Product	Revenues	quarterEndDate(date)	quarterEndDate(timestamp)
CD	$200	09/30/2021	06/30/2021
Hard disk	$600	09/30/2021	06/30/2021

Use the following steps for detailed instructions on how to use the quarterEndDate() conversion function to tackle the second example above in an insight:

Note

In the Cluster Management Console (CMC), create a tenant that includes Sample Data. The Sample Data includes the SALES schema.

In the Navigation bar, select the Content tab, and then select + New → Add Dashboard.
In the Add Dashboard dialog, for Name, enter Product Dashboard, and then select Add.
In the Action bar, select + (add icon), or select + Add Insight.
In the Insight panel, select Listing Table or V.
In Tables, select Aggregated Table.
In the Data panel, select Manage Dataset.
In the Manage Data Sets panel, in Tables, select SALES. Close the panel.
From the Data panel, drag and drop the following columns to the respective tray:
- Category from the PRODUCTS table to the Grouping Dimension tray.
- Revenue from the SALES table to the Measure tray.
  - In the Properties panel, for Number Format, select Dollar Rounded.
From the Data panel, drag and drop Add Formula to the Grouping Dimension tray.
The Formula Builder automatically opens:
- In Search Functions, select the down arrow, and then select Conversion Functions.
- Double-click the quarterEndDate function, quarterEndDate(), to add the formula to the editor.
- In the Formula Editor, replace date_timestamp exp with TIMESTAMP("2021-05-20 03:09:11")

quarterEndDate(TIMESTAMP("2021-05-20 03:09:11"))

Select Validate & Save.
In the Properties panel, for Column Label, enter quarterEndDate().
Name the insight Revenue Per Product Category.
In the Action bar, select Save.

Content

Signature

Returns

Examples