Identify tests with different statuses and tests execution between (x) to (y)

[Thansi224]

Trying to fetch tests where

---
TestRunStatus in (PASS, TODO, EXECUTING, FAIL, ABORTED, "N/A", BLOCKED, DEFERRED)

AND

Test execution between (x) and (y).

 ---

In test executions have around 100 tests.

1. Test Cycle1 before 2nd Aug we have successfully completed 50 tests and paused our test execution, outstanding tests we are planned to test in next Test Cycle2.

2. Before TestCycle2 updated all the tests and testexecutions to new fixversion on 2nd Aug.

3. In Test Cycle2 from 2nd Aug we are re-running outstanding tests includes (TODO, EXECUTING, FAIL, ABORTED)

If I execute above query I should be expecting only 50 tests with their current status but I am getting 100 tests

Question: Is there any way I can fetch tests have been updated between 2nd Aug to current day