SSRS Date Formatting Question

[BK Searcy]

I've developed a report that uses a start and end date in the where
clause and I have a time period selection parameter for the user to
select options of Previous Week, Previous Month, YTD, etc. I have a
stored procedure that calculates the start and end for each of the
options and all seems to be working correctly as far as the correct
dates being returned and populated as default values in my Start and
End parameter fields. The one thing I'm running into is that in some
cases the value is returned as just the date and sometimes it is
returned as Date and Time. Seems to depend on what my DateAdd/
DateDiff uses for that particular calculation. I want the values
returned as just the date each time. I tried adding
"CONVERT(VARCHAR(10), date calc, 101) to the stored proc date calc to
get a MM/DD/YYYY returned, however the report errors with "The
property "DefaultValue" of report parameter "StartDate" doesn't have
the expected type". Start Date is defined as a DateTime field.

Does anyone have a quick fix to this to get the defaults to display as
date only?

Thanks for any assistance.

BK

 

[Lars Hammarberg]

If you check the default value settings for your parameter in SSRS, do you
use null, a query or non-query value for the default?

 

[BK Searcy]

I'm using the query described in my original as the default value