Hello

I try to provide already for a long time with Visual Studio 2008 a report.
Test for list contents functioned without problems however I has the following two filters problems...

• I need a SQL statement where me the provided Incidents from the previous day indicate.

This is my Version

inc.ACTUALSTART >=(CAST( FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME ) -1)
AND inc.ACTUALSTART =(CAST( FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME ))

Whit this i receve the messages:

Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 5, position 10.

This is my Version

• need a SQL statement where me the provided Incidents from the previous day indicate. DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)-7 to retrieve the previous weeks monday and DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)-1 to retrieve the sunday.

Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 5, position 10.

Can you help me for my Filter settings

Regards Andreas Gilgen

I have one would list with problem incidents where I gladly to now filter would like after day or week.

1. I need a filter where show me the provided elements from the previous day (filter field:actual_start)
2. I need a filter with the provided elements, from the past week (Monday until Sunday) (filter field: actual_start).

I have this already times had and used for an Oracle query

I need now exactly the same however for ms sql

regards