BusinessObjects Board

prompt issue

Hi

I have developed custom sql report in webiXIR2. I have used prompt syntax in that report. user wants by default last day of perious month value. how can i achive this.

Please help


stalint (BOB member since 2004-12-14)

Hi just check if this formula can help you.

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

BOUSER86 (BOB member since 2010-10-04)

Thanks for reply. I am using oracle data base. I can use this condition in the query to reterive the data but user want this data in the prompt by defult.

and abc between ‘01-JAN-2011’ and trunc(sysdate,‘MM’)-1

is it possible to get the detault value in prompt boxir2.

Please advise.


stalint (BOB member since 2004-12-14)

Hi,

look at this link the second question. this may help you get a answer


BOUSER86 (BOB member since 2010-10-04)