Trying to create a formula to only count completed tickets in a certain date range.

Trying to create a formula to only count completed tickets in a certain date range.

Here is what I have but I get not results from it

countif(("Request"."Request Pending Status" = 0) AND ("Request"."Completed Time" >= DATE(2024-04-01) AND "Request"."Completed Time" <= DATE(2024-07-01)))

                New to ADSelfService Plus?