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
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)