How to substract date tin SSRS Report
I want to substract the dates in run time in SSRS report, ex:- if I choose end date as 13th of this month, then Start date should be 7th of this date, and I do not want to select the start date, it will automatically substract 6 days from 13th and report will show the data from period 7th to 13th. Please let me know the if it possilbe of not, & How.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
I have one more doubt,
Will the date automatically change when, I change the end date after running the report 1st time.
I have one more doubt,
Will the date automatically change when, I change the end date after running the report 1st time.
When you select the date parameter as End Date that can be used to show all data from last 7 days.
Ex: In the expression if you select Today() it will be “14th March 2011”
So for between condition you have pass the same parameter “BETWEEN Today()-6 AND Today()”
It will be taken as “08th March 2011” AND “14th March 2011”
It depends what control you are using in the Report
Ex: In the expression if you select Today() it will be “14th March 2011”
So for between condition you have pass the same parameter “BETWEEN Today()-6 AND Today()”
It will be taken as “08th March 2011” AND “14th March 2011”
It depends what control you are using in the Report
@prashant04: Yes the date automatically change each and every time when you run.
ASKER
I have applied the same before, but the sugesstion given by him was good
ASKER