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
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Remove expired dates from an end date report.

edited Mar 28, 2017 4:16PM in Reporting and Analytics for HCM 4 comments

Summary

End dates of before the current date are appearing on my report.

Content

Hi,

I have produced a report on end dates, such as fixed term and probation end dates. The idea of report is to show employees (in a trafflic light style) that are coming to an end of their fixed contract/ probation/ temp promotion. I have set the report fine (as shown in Example 1) but I keep seeing employees whose end date has expired. I would only like the report to show employees who have an end date as of today onwards.

I am using another report as an example, which works fine. The only difference in our reports is what is shown in example 2. I have left this blank as when I enter this formula my report no longer works in the analysis or dashboard. Can anyone tell me where I am going wrong? Hope ive explained that well.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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