BI Publisher (MOSC)

MOSC Banner

Date comparison

edited Aug 19, 2020 4:24PM in BI Publisher (MOSC) 1 commentAnswered ✓

Hi,

XML Template header need to print  max date of  ship_date or c_confirm_date. Both are coming on the xml data file.

      <SHIP_DATE>21-AUG-20</SHIP_DATE>

      <C_CONFIRM_DATE>30-AUG-20</C_CONFIRM_DA

<?xdofx:greatest(xdofx:to_date(ship_date,'DD-MON-YY'),xdofx:to_date(c_confirm_date,'DD-MON-YY'))?>

However it's printing :  19-AUG-2020 08:56      --> Seems current date. No idea on time how it's deriving.

Does not seem to be doing the actual date comparisons.

Need to print:  30-AUG-20

Any input how to fix it.

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