Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Publisher

Lisa O'Kelley · 2024-05-15 15:23:43

Hello! We are trying to find a formula for a scheduled report job to run monthly on the 28th of each month. Currently the report parameters contain formulas as follows: Current Month Date: {LAST_DAY_OF_MONTH()$} Prior Month Date: {FIRST_DAY_OF_MONTH()-1$} However, we need a formula that shows the 28th (or a specific date…

Scheduled report jobs current & previous month formula for a specific date each month

Received Response

118

Views

Comments

Answers

Kevin M-Oracle Rank 6 - Analytics Lead

May 16, 2024 8:05PM

You are welcome.
Kevin

0

MFA for Oracle Community

Oracle Analytics Publisher

Categories

Scheduled report jobs current & previous month formula for a specific date each month

Answers