<div>
<div class="content wysiwyg-content">
I have a report with two parameters input by the user. One is the End Date and the other is the number of days. In my report heading, I need to calculate the time period. The report will list 6 periods. I need to calculate the dates for the report header. The current period will be something like this 12/04/2014-12/31/2014. The period before that 11/06/2014-12/03/2014 etc... In access I use the below for the period before the current. <br />
<br />
L5.Caption = Format([Forms]![frmSRSRepo<wbr />rt]![txtEn<wbr />dDate] + 1 - (2 * [Forms]![frmSRSReport]![tx<wbr />tDays]), &quot;mm/dd/yy&quot;) &amp;&nbsp;&quot; - &quot;&nbsp;&amp; Format([Forms]![frmSRSRepo<wbr />rt]![txtEn<wbr />dDate] - 1 * [Forms]![frmSRSReport]![tx<wbr />tDays], &quot;mm/dd/yy&quot;)<br />
<br />
I have tried using the below in an SSRS expression but it give me an error. I have also tried using DateAdd. I think it is having a problem with multiple calculations against the date &nbsp;- like +1 - (2* SubtractDays). How can I do this in SSRS?<br />
<br />
=Format(Parameters!EndDate<wbr />.Value + 1 - (2 * Parameters!SubtractDays.Va<wbr />lue), &quot;mm/dd/yy&quot;) &amp;&nbsp;&quot; - &quot;&nbsp;&amp; Format(Parameters!EndDate.<wbr />Value - 1 * Parameters!SubtractDays.Va<wbr />lue, &quot;mm/dd/yy&quot;)<br />
<br />
Thanks
</div>
</div>


I have a report with two parameters input by the user. One is the End Date and the other is the number of days. In my report heading, I need to calculate the time period. The report will list 6 periods. I need to calculate the dates for the report header. The current period will be something like this 12/04/2014-12/31/2014. The period before that 11/06/2014-12/03/2014 etc... In access I use the below for the period before the current. 

L5.Caption = Format([Forms]![frmSRSReport]![txtEndDate] + 1 - (2 * [Forms]![frmSRSReport]![txtDays]), "mm/dd/yy") & " - " & Format([Forms]![frmSRSReport]![txtEndDate] - 1 * [Forms]![frmSRSReport]![txtDays], "mm/dd/yy")

I have tried using the below in an SSRS expression but it give me an error. I have also tried using DateAdd. I think it is having a problem with multiple calculations against the date  - like +1 - (2* SubtractDays). How can I do this in SSRS?

=Format(Parameters!EndDate.Value + 1 - (2 * Parameters!SubtractDays.Value), "mm/dd/yy") & " - " & Format(Parameters!EndDate.Value - 1 * Parameters!SubtractDays.Value, "mm/dd/yy")

Thanks

SSRS DateAdd function

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.