If your report parameter is not defined as a date - it should be...if you are calling a stored procedure and the input parameter is not defined as a date/datetime/datetime2 data type - it should be.
If you are using CAST or CONVERT to modify the format of a column to a specific format - stop doing that. Formatting a report column is much better done in the text field - especially since you can use a format that translates to the end users regional settings (if needed).
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster[/url]
Managing Transaction Logs[/url]