Remove expired dates from an end date report.
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.