Get Started with Redwood for Oracle Cloud HCM Begin Now
Adding 2 date parameters to a report
Summary
Report needs to report either by Termination Date Range OR Last Update Date RangeContent
I have built a report that has 2 date Ranges on it
Change Date From and To
Termination Date from and To
I couldn't figure out how to use one or the other parameter so I just pick up termination dates for the current year
AND to_char(pps.actual_termination_date, 'YYYY') = to_char(sysdate, 'YYYY'
I have logic setup on the Last Update Date to use the parameters setup (and if nothing is entered into the field, to default to the current day - 14 days)
1