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

Remove expired dates from an end date report.

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


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



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.


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