Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Setting relative dates in a filter for an OTBI Analysis — 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

Setting relative dates in a filter for an OTBI Analysis

Accepted answer
255
Views
17
Comments
edited Apr 28, 2017 1:29PM in General Transactional Reporting (OTBI) 17 comments

Summary

In an OTBI Analysis is there a way to add into a relative date range into a filter?

Content

I need an Analysis with a filter to pick up dates within the last week.  I don't see a way to do this in the normal filter properties and I'm getting errors when i add the below code into "Convert this filter to SQL"  Is there a way to do this either with the regular filter or with the Advanced SQL filter?  

 BETWEEN (SYSDATE - 7) AND SYSDATE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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