SSRS 2005 Table Filter, getting last 3 years

is the field datetime?
if yes, you shall not need the CDate()
also, don't use the ToShortDateString() function, because if it returns the date in format MM/DD/YYYY (or certain other formats that are not YMD), the >= cannot work, as it will be compared on the string bases, not on the date bases.

finally, "now -3 years": should that be "now - 3 years" (=> 20/04/2006 .. today ), or this and the previous 2 full years ( => 1/1/2007 .. today ), or what?

The field is datetime.
I need:   now - 3 years" (=> 20/04/2006 ..

So if I have my field date as 20/04/2005 I do not want to list it, but if my date field is 20/04/2006 I do want it listed.  

that would be, with pure sql server: not sure if that applies to srs:

your_date_field > dateadd(year, -3, convert(datetime, convert(varchar(10), getdate(), 120), 120) )

Select allOpen in new window