Between Dates

[jmonroe918]

What is the best way to filter data between dates?

I am trying to count records where

Status<> Closed and Today is after Sched Date and Today is before Intended Completion Date.

Here is my Expression:

=Count(DISTINCT{<
[Internal Audits.Status]-={'Closed'},
[Internal Audits.Sched Date]={"<=$(=Date(Today(),'MM/DD/YYYY'))"},
[Internal Audits.Intended Completion Date]={">=$(=Date(Today(),'MM/DD/YYYY'))"}

>}[Internal Audits.Audit No])

I run the report and I am not picking up one record where the status is Not Closed, the Sched Date is 3/1/2014 and the Intended Comp Date is 4/13/2014.

Is there an issue with my Expression? Is there a better way to filter between dates?

Jeff