BusinessObjects Board

dynamic dates in Query Builder

other Business Query
#1

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!

ethan1701 :israel: (BOB member since 2004-05-05)

#2

How are you solved this problem?

cgarcesg :es: (BOB member since 2005-11-14)

#3

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.

Philip (BOB member since 2006-03-02)