The below time stamp query that is pulled in with a R & H event or network feature class doesn't always work:
(FromDate is null or FromDate<=CURRENT_TIMESTAMP) and (ToDate is null or ToDate>CURRENT_TIMESTAMP)
We often have to replace it with ToDate is NULL - which doesn't always work either.
We are working on 10.4.1 with Patch 1. Does anyone have an idea what is happening?