title: Reporting Services: DateTime parameter not showing the time part when its midnight
body: <p>I need to add a 'StartDate' parameter to a report in Reporting Services 2005, which should represent the current date, at midnight.</p>
  
  <p>If I use Now() as expression, it will correctly use midnight in the calculations, but to the user, the time part will not be shown.</p>
  
  <p>13/12/2011</p>
  
  <p>which can be confusing because then the user doesn't really realise he or she can type in a time part.</p>
  
  <p><em>How can I format this date to the following:
  13/12/2011 00:00 
  <strong>while keeping the parameter as a DateTime datatype</strong>.</em><strong>?</strong></p>
  
  <p>Edit: I've checked the duplicate question and tried to apply it to my case, but run into the following phenomenom:</p>
  
  <p>If I try:</p>
  
  <pre><code>=DateTime.Parse(Format(Now().Date().AddSeconds(1), "dd/MM/yyyy HH:mm:ss"))
  </code></pre>
  
  <p>Then the parameter shows "14/12/2011 00:00:01" which is confusing for the users, so I then tried the following:</p>
  
  <pre><code>=DateTime.Parse(Format(Now().Date().AddSeconds(1), "d/M/yyyy HH:mm"))
  </code></pre>
  
  <p>But then the parameter shows "14/12/2011" again! In other words, the time part is gone again!</p>
  
  <p>Who invented this stuff? :P</p>