Built-in Functions → monthEndDate

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

Signature

Copy
monthEndDate(date_timestamp exp)

The following table illustrates the monthEndDate() parameter:

Returns

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

Examples

• Identify the last date of the current month for the given date, 08/17/2021.

Copy
monthEndDate(
    date(
        "2021-08-17"
    )
)

• Identify the last date of the current month for the given timestamp, 2021-07-20 03:09:11.

Copy
monthEndDate(
timestamp(
"2021-07-20 03:09:11"
)
)

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

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

• 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 monthEndDate function, monthEndDate(), to add the formula to the editor.
  • In the Formula Editor, replace date_timestamp exp with TIMESTAMP("2021-07-20 03:09:11")

Copy
monthEndDate(TIMESTAMP("2021-07-20 03:09:11"))

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