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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Using SET VARIABLE PARAM_EFFECTIVE_DATE

edited Mar 10, 2020 2:17PM in Reporting and Analytics for HCM 5 comments

Summary

I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 days

Content

I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix.  I want to use the current date minus 3 days.

I've tried something like this but it's not working.  The "TIMESTAMPADD(SQL_TSI_DAY, -3,CURRENT_DATE" gives me today minus 3 days in the report.  But I don't have the correct syntax.

I've tried...

SET VARIABLE PARAM_EFFECTIVE_DATE='@{TIMESTAMPADD(SQL_TSI_DAY, -3,CURRENT_DATE}';

Anyone know what I'm missing?

Thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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