Issue with RTF If Condition in Footer

[Junaid.Niazi]

Dear Erman,


I’m facing an issue with the footer’s IF statement. When I include two conditions, only the first one is reflected in the report output.
Code:

<?xdofx: if StsCode =’ACTIVE’ and To_char(EFFECTIVE_START_DATE, ‘DD-MM-YYYY’) > (’01-01-2025’) end if?>  

regards
Junaid

[ErmanArslansOracleBlog]

Use the Correct BI Publisher (XDO) Syntax.
Also state there what to display if the condition is true.