How to query data where the status gets changed at that point in time by filtering from a generic date?

[nivitha18]

Hi ALL,

I have a problem, where I should be able to query a set of data which may change from the point in time when the query is run

example is attached, it would be great if someone can assist me.

Thank you in advance