Hi Team,
We are using LEAST() and GREATEST() functions between 2 dates, for calculating date field in DB level need to do same logic in RDP/Report level.
Logic:
Case when to_char(LEAST(DATE1, DATE2),'YYYY') < 2018
then GREATEST(DATE1, DATE2) else LEAST(DATE1,DATE2) end as New Date
Can someone help how to use LEAST and GREATEST function in OBIEE RPD/Report level.
Version we are using: Oracle Business Intelligence 12.2.1.4.0
Thanks in Advance