in SSRS i am using two variables without declaration @Start_Date and @End_Date and map these two variables report parameters and declare that two parameters datatype as datetime but in preview when i enter date more then 12 it shows the following error "the value provided for the reprt parameter 'Start_Date' is not valid for its type. " please help and advice me where i am making mistake Regards, Amitesh Srivastva

I'd guess you're trying to enter a date as dd-mm-yyyy while the report is expecting mm-dd-yyyy (or the other way around). First try entering your date with the day and month reversed and see if that works. If it does, then you need to change the Localization properties of the report to one which has the data in the appropriate format; e.g. en-UK uses dd-mm-yyyy while en-US uses mm-dd-yyyy .If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.

YES YOU ARE RIGHT here is problem calender is taking date as dd/mm/yyyy and due to this problem arises , now please guide how can i change Localization Property. no where si found this property in report , please guide. Regards, Amitesh Srivastva

We'll need to know what software you're using to design the report. I use BIDS and can access all the properties in the Properties window (press F4 to open the window, select Report from the drop-down list and then scroll down to localization). If you're using a different editor, someone else will have to guide you.If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.

Hi Amitesh_Srivastva, When preview a report in Business Intelligence Development Studio, the parameter date/time format is same with our operating system. To check the operating system date format, please open Region and Language settings in Control Panel, click Formats Tab, and find Short date setting. However, after deployed a report on Report Server, we can use IE to access a report. The parameter date/time format of a report is decided by IE languages settings. To check languages setting, please click the Tools button->Internet Options->languages. Best Regards, Bin Long

Hi, According to my understanding you are having two parameters as date time. What you can do is in your query or stored procedure where you are passing date use datatime functions to convert date into the specific format. Please mark as answer if this post helps. Thanks, Shobhit