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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

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

dynamic dates in Query Builder


 
Search this topic... | Search Business Query... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Business Query  Previous TopicPrint TopicNext Topic
Author Message
ethan1701
Principal Member
Principal Member



Joined: 05 May 2004
ASUG Icon
Posts: 334
Location: Israel


flag
PostPosted: Tue Oct 21, 2014 8:26 am 
Post subject: dynamic dates in Query Builder

I want to build a query that I can run on a daily basis (in an automated script), that'll show me reports that were created yesterday.

something along the lines of SELECT * FROM CI_INFOOBJECTS WHERE SI_UPDATE_TS > DATEADD(DD,-1, GETDATE())

But it looks like using GETDATE() does not work.

Is there any way of using a dynamic parameter to do what I'm trying?

Thanks!

_________________
BusinessObjects Enterprise XI 4.1 SP6
Windows 2008
SQL Server 2014
Tomcat7
Back to top
cgarcesg
Senior Member
Senior Member



Joined: 14 Nov 2005

Posts: 59
Location: Zaragoza, SPAIN


flag
PostPosted: Tue Nov 04, 2014 5:19 am 
Post subject: Re: dynamic dates in Query Builder

How are you solved this problem?
_________________
Un saludo,
CÚsar
BO XI r2 JAVA.
BO 4.0 SP4
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 606
Location: USA



PostPosted: Thu Dec 19, 2019 11:28 am 
Post subject: Re: dynamic dates in Query Builder

Any solution of this issue? Same issue goes with me now.
select * from CI_INFOOBJECTS WHERE SI_ENDTIME>DATEADD(SECOND,100,SI_STARTTIME)
It is saying, Not a valid query. (FWB 00025)

Appreciate your help on it. I am using SQL server.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Business Query  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.0392 seconds using 18 queries. (SQL 0.0144 Parse 0.0009 Other 0.0239)
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