Solution Found:

Line: chppon Not In ('OUT', 'NAB', 'NHB',' ', 'NON') was missing second )

should of read: chppon Not In ('OUT', 'NAB', 'NHB',' ', 'NON'))

otherwise it...

I tested that but it still doesn't like that second select for some reason

New error:

Msg 156, Level 15, State 1, Line 12

Incorrect syntax near the keyword 'Select'.

;with cte as (select chppon, datediff(day,

case when chrcdt between 19000101 and 30000101 then

convert(date,cast(chrcdt as varchar(8)),112) end,...

unfortunately it is built into the software that way. I cant alter the production database column types. I can create temp tables.

Lowell (3/17/2016)

---

i think your issue is you are storing...

Can you provide an example as I am not used to this version of SQL?

Yes it worked. I just wanted to make sure incase I need to run the other direction as this query is about 12 pages long already. Working with over 300...

So in order to Flip this Statement to True what would I change "Not in" too?

can you give me an example of how to place that statement?

Does it go in the FROM section or the WHERE section?

unfortunately I do not have those options see screen shot attached.

Luis Cazares (3/10/2016)

---

What do you mean by have not...

The value provided for the report parameter 'ChkPrintDate' is not valid for its type.

This is the error produced on my front end.

I am told that both of those are incorrect

with a basic error of Value not recognized.

=DateAdd("d",-1,Today())

I am assuming it would be

=DateAdd("d",+1,Today())

or

=DateAdd("d",1,Today())

which have both not worked.

so in SSRS what if I wanted the date to always be tomorrows date?