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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> "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
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
ASKER