Adding 2 date parameters to a report — Cloud Customer Connect
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: Oracle Cloud SCM and Purchasing

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!