Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Date Parameter

Author  Topic 

squashjunkie
Starting Member

9 Posts

Posted - 2007-05-24 : 08:39:36
I have a date parameter which I want to use to filter sales by.
The default for the parameter is set to TODAY(), but as soon as that is changed, the report throws an error
The value provided for the report parameter End_Date is not valid for its type
The parameter is set as DATETIME format so that I can use the calendar control, but how to convert it so tht it uses the correct format in the query in my dataset?
(As I am using English language settings, the parameter shows e.g. 24/05/2007)

Any ideas? Thx

"Do or do not. There is no try"
   

- Advertisement -