title: SSRS adding default time to a date parameter
body: <p>I have an SSRS report with two parameters that are datetimes. Of course the date selector doesn't allow you to select times to go with the dateTIME, that would make too much sense. So my idea was to give the datetime parameters a default time. For example, if I wanted the default value of a parameter to be today's date at 8:30 AM, how would I do that?</p>
  
  <p>So if today was 9/4/2013 I want to see exactly this: 09/04/2013 8:30 AM. </p>
  
  <p>I have tried all kinds of formatting. The closest I got was doing this:</p>
  
  <pre><code>=CDate(Format(Today(), "MM/dd/yyyy") &amp; " 8:30 AM")
  </code></pre>
  
  <p>But I have never been able to get the seconds to not show up because you always have to convert this back to a datetime from a string, otherwise you get an invalid type error, and CDdate ALWAYS displays the seconds.</p>