Date filter not working when a report has more than 1 date field

[crackie]

Hi there,

Has any1 came across a situation where you have a report with 3 dates.  For instance you want to see how many files per hour were loaded in a particular day.  You will have a File date - Load Start and Load End.  When you apply a filter on File Date - it throws an error.  When you remove the other dates (Load start and Load End) it's working perfectly.

Rgds

[BIsrik]

check the data types of the two fields..r u using any charecter function in the filter..

Srik

[crackie]

thank you for your reply, this is how I created the filter.
cast_date([DSS2 Data Source View].[t_event_gap].[file_date]) = cast_date( getdate ( ) -1)

I know the other two date fields are datetime as I need to calculate hours from them as well.