nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?

Gavi

Hi everyone,
I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, or if there are any alternative solutions.

Find more posts tagged with

Date

Accepted answers

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70678#Comment_70678

Hi @Gavi,

You can achieve last day of previous month by using the following function in the default value:

Last day of the previous month:

{$FIRST_DAY_OF_MONTH()-1$}

The First Day of Previous Month functions are not supported in the BI Default Date parameters.

Here is a workaround:

Create an LOV:

SELECT ADD_MONTHS((LAST_DAY(SYSDATE)+1),-2) FROM DUAL

Now create a Menu parameter based on the above LOV.

Hope this help.

Thank you.

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26986/how-to-set-first-day-and-last-day-of-previous-month-as-default-value-for-parameters

Hi @Gavi,

Welcome to the Oracle Analytics Community!

Please use the following as default values, it should work.

First Day of Month: {$FIRST_DAY_OF_MONTH()$}
Last Day of Month: {$LAST_DAY_OF_MONTH()$}

Hope this help.

Thank you.

Gavi

Hi Bhaskar,
Thanks for your reply.

I tested {$FIRST_DAY_OF_MONTH()$} and {$LAST_DAY_OF_MONTH()$}, but they give the first and last day of the current month.
What I actually need is the first and last day of the previous month.

Is there a way to shift these functions by -1 month, so the parameter defaults to last month’s range instead of this month’s?

Thank you again for the help!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/70678#Comment_70678

Hi @Gavi,

You can achieve last day of previous month by using the following function in the default value:

Last day of the previous month:

{$FIRST_DAY_OF_MONTH()-1$}

The First Day of Previous Month functions are not supported in the BI Default Date parameters.

Here is a workaround:

Create an LOV:

SELECT ADD_MONTHS((LAST_DAY(SYSDATE)+1),-2) FROM DUAL

Now create a Menu parameter based on the above LOV.

Hope this help.

Thank you.

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders