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