Error when applying a filter to a table

Table Properties, Filter Tab.
Added a filter.
Expression: =Fields!LastActionDate.Value
Operator: = Value: "7/1/2004"
Receive following when previewing report:
"An error has occured during report processing. The processing of
filter expression for the table 'table1' cannot be performed. The
comparision failed. Please check the data type returned by the data
expression."
I tried Expression: =CDate(Fields!LastActionDate.Value)
I tried removing quotes from Date value.
No Luck.
Can someone help?
Thank you!You'll also need to cast the filter Value: =CDate("7/1/2004")
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"The Whistler" <sharris@.SLeasynews.com> wrote in message
news:s6puh0pvgceg530k3sfagtefa3qogid418@.4ax.com...
> Table Properties, Filter Tab.
> Added a filter.
> Expression: =Fields!LastActionDate.Value
> Operator: => Value: "7/1/2004"
> Receive following when previewing report:
> "An error has occured during report processing. The processing of
> filter expression for the table 'table1' cannot be performed. The
> comparision failed. Please check the data type returned by the data
> expression."
> I tried Expression: =CDate(Fields!LastActionDate.Value)
> I tried removing quotes from Date value.
> No Luck.
> Can someone help?
> Thank you!
>
>