Querry for pending requests until a specific month

Querry for pending requests until a specific month

Hello together,

i need a querry to show the following records:
All request types with request status = open until 31. August 2021 23:59 . 
So this means that i need a way to look into the past how many ticket was still open until this date/time.


                New to ADManager Plus?

                  New to ADSelfService Plus?