title: Remove Time From SSRS Date Parameter
body: <blockquote>
  <p>I want to remove the time from my Parameter Selection Dropdown, NOT a cell referencing the parameter</p>
  </blockquote>
  <p>I have a simple parameter <code>weekEndingDate</code> which is fed by my <code>dataset</code></p>
  <pre><code>SELECT TOP (8) Convert(Date,FullDate, 101) AS FullDate
  FROM DimDate
  WHERE (DayNameOfWeek = 'Friday') AND (CAST(FullDate AS Date) &lt; CAST(GETDATE() AS Date))
  ORDER BY FullDate DESC
  </code></pre>
  <p>I have also tried</p>
  <pre><code>SELECT TOP (8) CAST(FullDate as Date) AS FullDate
  FROM DimDate
  WHERE (DayNameOfWeek = 'Friday') AND (CAST(FullDate AS Date) &lt; CAST(GETDATE() AS Date))
  ORDER BY FullDate DESC
  </code></pre>
  <blockquote>
  <p>The issue is that the parameter options still display time.</p>
  </blockquote>
  <p>If I execute the query in Query Designer I get basically correct output (Convert is giving me <code>m/dd/yyyy</code>, instead of <code>mm/dd/yyyy</code>) and this is true for cast and convert, but the parameter drop down still has time, and if I put the parameter into a cell, it also has the time</p>
  <blockquote>
  <p>I have deleted the .data files</p>
  <p>I have deleted and recreated the parameter, but did not deploy or rebuild or anything WITHOUT the parameter, I deleted and immediately recreated then hit Preview</p>
  <p>I have tried both CAST and CONVERT</p>
  <p>I have tried Previewing, Running, and Deploying the report</p>
  </blockquote>
  <p>In all cases the time remains and I am dumbfounded, all help appreciated, and I'm happy to clarify anything</p>