I ned advise on how to best set up parms in the SSRS and the SQL for the following WHERE clause in my Query. The year date is the problem here. I get a value of 2013 from my dropdown and need to pass into the SQL. And so I can set up the next parm to be the current year minus 90 days.
I'm stuck on how to declare and concatenate the values in the SQL
here is the where:
(m1.MemberEffectiveDate between '01-01-2013' and '12-31-2013'
m1.MemberEffectiveDate between '10-03-2012' and '12-31-2012'
and (j2.dateofcompletion not between '10-03-2012' and '12-31-2012'
or j2.dateofcompletion is null)
thinking out loud i need a @jan = '01-01-' and concatenate to the @year but how??