Cannot find specific date through Prompt

Andrew Fomin.

My guess is that your date field has time. So you are comparing something like '02/20/2016' and '02/20/2016 10:15:18'.

To find out what is really going on, you need to get the exact SQL which goes to the database and then understand why it does not work as intended.

1. Turn logging on and cache off: open the report, go to the Advanced tab and type "SET VARIABLE DISABLE_CACHE_HIT=1, LOGLEVEL=2;" into the prefix field. Press Apply SQL. Save the report.

2. Go to the Dashboard and execute the report. This will generate logs we need.

3. Go to "Administration" -> "Manage sessions" and find your report execution log. It is somewhere at the bottom.

4. Click View Log.

5. Find the exact SQL query (queries).

6. Copy and paste it into your favourite SQL tool and find out why it is not working as intended.

7*. Don't' forget to remove SET VARIABLE... from the report.