ssrs expression to find count of records which falls beween two dates

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65144 More actions · Answer 1

Your conditions look wrong, you cannot have a date that equals today and is less than 30 days ago!

You can use sum and iif in an expression to count rows, ie

=SUM(IIf(SubmittedDate>DateAdd(DateInterval.Day,-60,Today) AND SubmittedDate<DateAdd(DateInterval.Day,-30,Today),1,0))

Far away is close at hand in the images of elsewhere.
Anon.

nilesh k Default port Points: 1457 More actions · Answer 2

Actually I am looking for something like "Between" operator in transact query... in short

select count(*) from table where CAST(submitteddate AS DATE) between '2015-02-02' and '2015-01-01'

Not sure if my below code is correct:

=Count(iif(DateDiff("d",SubmittedDate,Now()) And DateDiff("d",SubmittedDate,Now()) <= 30,0,NOTHING))

David Burrows SSC Guru Points: 65144 More actions · Answer 3

Try

=Sum(IIf(DateDiff(DateInterval.Day,Fields!SubmittedDate.Value,Today)<=30,1,0))

Far away is close at hand in the images of elsewhere.
Anon.

nilesh k Default port Points: 1457 More actions · Answer 4

Hi David,

how to find count of the records for dates between today()-31 and today()-60?

David Burrows SSC Guru Points: 65144 More actions · Answer 5

Sum(IIf(DateDiff(DateInterval.Day,Fields!SubmittedDate.Value,Today)>=31 AND DateDiff(DateInterval.Day,Fields!SubmittedDate.Value,Today)<=60,1,0))

Far away is close at hand in the images of elsewhere.
Anon.

Cookies on SQLServerCentral