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.

New Announcement

Upcoming Changes to the Oracle Analytics Workbook Authoring Experience
Hello, Starting with the OAC September 2026 update, you’ll notice some changes to the Workbook authoring experience. The Data, Visualize, and Present tabs will no longer be displayed at the top of the Workbook. Here’s how you can navigate between these experiences going forward. Presenting and configuring a presentation…

New Event

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Concepts, Use Cases, and Architecture
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…