Link to home
Start Free TrialLog in
Avatar of jnikodym
jnikodym

asked on

SSRS - Filter to show dates within the next six months

I have a report that i only want to show records where the due date is between the first day of the next calendar month and the last day of 6 months from the first day of the calendar month.  For example if i ran the report today (5/19/2016).  I would want to see all records with a due date of 6/1/2016 to 11/30/2016
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jnikodym
jnikodym

ASKER

That is close.  It is still returning the 5/31/2016 records.
> "5/31/2016 records"
oops! ... use 1 for the day argument instead of 0 (this will return last day of previous month -- cool that DateSerial will do that)

use >= for the first date. For the last date, I would suggest doing < 1 day after what you want since date can also have a time component