Hi Siera_gld, In your statement, you mentioned that “if I use this select convert(char(10), dateadd(d, -30,getdate()), 23) as BEG_DT_LBL and try to pass it in it throws an unexpected datatype error in rendering” I am not sure you pass this datafield to where, if you pass it to your parameter’s default value, you have to convert it to be a date type, as Calendar could only receive date type value as its default value, if you want to pass calendar’s value to store procedure, you still need to convert the datetime to short time type, as default date type for calendar is longdatetime format such as “07/26/2010 00:00:00”. If we select 07/26/2010 its default value is 07/26/2010 12:00:00 AM. So if you want to pass the value in short time type, please format the datetime to be short date format using the function “FormatDate” before passing in the dataset. =FormatDateTime(Parameters!<Report_Parameter>.Value,2) For more information about FormatDate, please see: FormatDateTime Function: http://msdn.microsoft.com/en-us/library/8aebkz6s(VS.85).aspx Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I have multiple datasources in a report that use dates as paramaters. I need my dates to appear as yyyy-mm-dd (2011-02-21) in the screen for input - and they need to be a date format so the end user can use the calander function in SSRS. I am trying to create a new dataset (dsBEG_DT) and use the following for values select convert(char(10), dateadd(d, -30,getdate()), 23) as BEG_DT_LBL , dateadd(d, -30,getdate()) AS BEG_DT_VAL I need to use this multiple times in my report and need to use it to reference in cascading paramaters. if I use this select convert(char(10), dateadd(d, -30,getdate()), 23) as BEG_DT_LBL and try to pass it in it throws an unexpected datatype error in rendering. My Stored procedure is using all datetime datatypes does anyone have any thoughts on this?KDW