Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Using Functions in Report Header and Footer — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using Functions in Report Header and Footer

Accepted answer
edited Jul 31, 2015 7:37PM in Reporting & Analytics for B2C Service 7 comments


I need to report the date of data in a report header (yesterday) as opposed to the date the report was created {CurrentDate}.

Is there a way to put the day before the report was run in the header or footer of a report?

{CurrentDate}-1 ?  or perhaps {date_add(sysdate(), -1, DAYS, 1)} ?  Can a Variable be added?

Thanks....  Cornelia


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!