BI Publisher (MOSC)

MOSC Banner

How to compare a date with system date in the rtf template

I have a scenario where if DUE_DATE is greater than system date, then it should print Due in black color, and if DUE_DATE is less than system date, then it should print Overdue in red color.

I have used the condition <?xdoxslt:if ORIGINAL_DUE_DATE>sysdate?> for priniting Due and <?xdoxslt:if ORIGINAL_DUE_DATE<sysdate?> for printing Overdue.

But it is printing both the values.

Can you please tell how to print the correct value based on the above condition?

Regards,

Kratika

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