BI Publisher (MOSC)

MOSC Banner

Need to compare date with sysdate and put condition in the parameter in bip desktop

edited Oct 4, 2016 6:26PM in BI Publisher (MOSC) 9 commentsAnswered

Hi

I have a requirement in BIP report(using bip desktop)where the condition would be

1. (Enddate<Startdate) and (Enddate<Startdate+5  or  Enddate=Startdate+5 ) and (Enddate<Sysdate)

I have declared two pareameters in the BIP rtf

$Startdate and $Enddate

I tried

a. <?if: ($Enddate-$Startdate<5 or $Enddate-$Startdate=5) and $Enddate>$Startdate ?>

b. <?if: ($Enddate<($Startdate+’5’) or $Enddate =($Startdate+’5’)) and  $Enddate>$Startdate ?>

But no result .I also cant compare the sysdate with the $Enddate also.

Please help.

Regards

Priyanka

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center