BI Publisher (MOSC)

MOSC Banner

How to add a Date Expiration Condition on a field?

edited Sep 22, 2015 10:02AM in BI Publisher (MOSC) 5 commentsAnswered

I have hardcoded text as well as a couple fields in my rtf template that have an expiration date associated to them.  In other words, the fields and text represent a discount percentage and that expires at the end of the year.

How do I write a condition on these fields and text so that they display for this year, but will not starting January 1?

<?if:RequestedDate<'2015-12-31'?>Discount<?end if?> does not work.  Can I go another route of using "if current_date() or sysdate()" is less than December 31, then display?  If so, what is the syntax for coding that into the template?  Thanks,

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