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

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…

Top Leaders