BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

specifying a set of dates over a period in the criteria


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
n2nuk
Forum Member
Forum Member



Joined: 04 Oct 2019

Posts: 7



PostPosted: Thu Oct 10, 2019 10:50 am 
Post subject: specifying a set of dates over a period in the criteria

I am reporting on an audit table and need to report on activity that occurred between two dates In July, August and September.

I can use the between parameter but this only lets me specify one set of dates, is it possible to report on all 3 date ranges at once?. the other option is to re-run the report 3 times with the different date ranges specified.

Thanks
Back to top
Ross_BOXI
Senior Member
Senior Member



Joined: 17 Apr 2018

Posts: 62



PostPosted: Thu Oct 10, 2019 11:00 am 
Post subject: Re: specifying a set of dates over a period in the criteria

It is possible
In the query panel have three between dates filters with the OR operand as opposed to AND
This will pull through data that satisfies any of the filters
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0260 seconds using 18 queries. (SQL 0.0024 Parse 0.0008 Other 0.0228)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo