﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Reporting Services / Reporting Services 2008 Development  / using parameter date - 21 days in field header? / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Mon, 17 Jun 2013 22:33:59 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: using parameter date - 21 days in field header?</title><link>http://www.sqlservercentral.com/Forums/Topic1420713-1633-1.aspx</link><description>You can refer to parameter values in the report using an expression like this:[code="other"]=Parameters!Parametername.value[/code]If the parameter is a date datatype, you can use the dateadd function[code="other"]=dateadd(DateInterval.Day,-21,Parameters!Parametername.value) [/code]Then write this into the format property for the text box [code="other"]MM/yy[/code]</description><pubDate>Tue, 05 Mar 2013 17:28:19 GMT</pubDate><dc:creator>davoscollective</dc:creator></item><item><title>using parameter date - 21 days in field header?</title><link>http://www.sqlservercentral.com/Forums/Topic1420713-1633-1.aspx</link><description>Looking to use a parameter filed -21 days for a field header in MM/YY format?Thanks</description><pubDate>Fri, 15 Feb 2013 11:54:06 GMT</pubDate><dc:creator>jbalbo</dc:creator></item></channel></rss>