# ssrs expression to find count of records which falls beween two datesRSS

## 5 replies

Last post Feb 03, 2016 05:37 PM by edwardsdna

• nileshvk

Member

24 Points

78 Posts

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

Hi All,

I need assistance in building SSRS expression to find count of records between two dates. below are my conditions:

1. Submitted Date = Today and Submitted Date <= Today()- 30

2. Submitted Date >= Today()-31 and Submitted Date <= Today() - 60

3. Submitted Date >= Today()-61

• Edwin Guru S...

Star

8536 Points

1376 Posts

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

Feb 02, 2015 08:45 PM|Edwin Guru Singh|LINK

hi nileshvk,
As per your case, the following ssrs expression which may solve this issue :

```1.=SUM(
IIf( (Fields!SubmittedDate.Value = Today()
And  Fields!SubmittedDate.Value< = Today()-30 )
, 1
, 0)

2.=SUM(
IIf( (Fields!SubmittedDate.Value >= Today()-31
And  Fields!SubmittedDate.Value< = Today()-60 )
, 1
, 0)

3.
=SUM(
IIf( (Fields!SubmittedDate.Value >= Today()-61)
, 1
, 0)```

--
with regards,
Edwin

with regards,
Edwin
• nileshvk

Member

24 Points

78 Posts

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

Hello Edwin,

these expressions does not get compiled successfully.

• Edwin Guru S...

Star

8536 Points

1376 Posts

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

Feb 03, 2015 12:11 AM|Edwin Guru Singh|LINK

#### nileshvk

these expressions does not get compiled successfully.

Where you placed this expression in your report ?
If possible ,post your report Screenshot & explain your expected output ?
--
with regards,
Edwin

with regards,
Edwin
• nileshvk

Member

24 Points

78 Posts

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

I am adding expression in legends section of the report. I have added screenshot, not sure it is visible to you as I cannot see it :(

• edwardsdna

None

0 Points

1 Post