I have found one thing out about this. Our Load Data Warehouse and Load Data Warehouse Rights job run every night. However, if I run this ad hoc query first thing in the morning, the data is incorrect. If I run the 2 Load Warehouse jobs, then run the report, it works fine. The status report date hasn't been changed, we only created a new one every 2 weeks. Not sure what to do other than run the jobs before running the ad hoc view.
Original Message:
Sent: 09-25-2020 04:06 PM
From: Teresa Maeder
Subject: Ad Hoc Date Filter Doesn't Always Work
Hi,
I have created a simple ad hoc view that filters on the project being active and a status report date. Changing the status report date when running the ad hoc view does not always display the correct information. If I remove the status report date filter and put it back on and select a date, it will work fine. What can I do to fix this?