Counting occurances of a date between two other dates
Hopefully someone can help... I have this situation where I have a date coming back as part of a dataset and i need to count how many times that date falls between two other dates (report parameters), I cant even get close on this, the expression i have now is returning a count of all rows...here is where I am at... =Count(IIF(Fields!DateSubmited.Value > Parameters!ReportPeriodStart.Value,0,Nothing) and IIF(Fields!DateSubmited.Value < Parameters!ReportPeriodEnd.Value,0,Nothing))
October 5th, 2011 9:06pm

Try =Sum(IIF(Fields!DateSubmited.Value > Parameters!ReportPeriodStart.Value AND Fields!DateSubmited.Value < Parameters!ReportPeriodEnd.Value,1,0))
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2011 10:21pm

Thanks a bunch...worked well!
October 6th, 2011 12:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics