sql server - TSQL Logic in SSRS -

Text after "

I am creating the PropertyStatementForHalfyear End Header field as a report: & lt; Date & gt; Based on the date of the report by entering 28 May or 28 November in the

field < / P>

What logic I ??

• For example, if I need to run the report today on June 22, I need to display PropertyStatementForHalfyear Finished: 28 November 2013 < / Li>
• If I run it in December 2013, I need to finish the PropertyStatementForHalfyear to display: May 28, 2014

  You could use something like this:

    announcement @ dateThreshold1 date = '20, 130,528 'announcement @ dateThreshold2 date = '20131128' DECLARE @CurrentDate DATE = ' 20131201 'If current account & gt; @ Date Traded 2 Selection Convert (VARCHAR (50), DATEADD (year, 1, date 1), 106) If @ current date & gt; @ DateThreshold1 Select CONVERT (VARCHAR (50), @ DateThreshold2, 106) and select CONVERT (VARCHAR (50), @ DateThreshold1, 106)   
   
    20,130,101 For the  20130528 , for the dates through  May 28, 2013   
    for the dates from 20130529 through  From  20131128 will return  28 November 2013   
   For the last  20131128 , this will return  to May 28, 2014 ,    
   You can easily package it in a function or SSRS code snippet