You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Adding 2 date parameters to a report

edited Jul 20, 2020 1:59PM in Reporting and Analytics for HCM 1 comment

Summary

Report needs to report either by Termination Date Range OR Last Update Date Range

Content

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!