OTBI Formula/SQL solution

Josh Dewar

Hi,

Wondering if someone can help my colleagues and I out, we have an issue with our date range on our Absence by Directorate report.

We have a SQL statement that would work in BI Publisher but were wondering if it's possible to recreate this in OTBI.

SELECT *FROM absences WHERE start_date <= TO_DATE('2024-06-30', 'YYYY-MM-DD')   AND (end_date >= TO_DATE('2024-06-01', 'YYYY-MM-DD') OR end_date IS NULL);