00/00/0

Summary

Cannot filter on report return

Content

Hi all

I am looking at working pattern reporting.

All our full time standard working hours peeps inherit their working pattern from the global tier and their effective start and end dates show as above.

Everyone else has their own working pattern in their HR record and displays dates in the normal format.

I am trying to filter out all the working patterns that are end dated however because the above is returning, it is filtering out all the standard people as well, if you will forgive the phrasing.

I have tried to include it in the filter however OTBI wont recognise it as a valid date.