title: Passing dates to parameter in SSRS
body: <p>In which format I should pass date field to parameter to be able to choose date picker insted of list?</p>
  
  <p>My query returns date (date format) and I cast it in a different ways (yyyy-dd-MM, yyyy-MM-dd, dd-MM-yyyy, ...) in SSRS:</p>
  
  <pre><code>=Format(Fields!StartDate2.Value,"yyyy-dd-MM")
  </code></pre>
  
  <p>I use this field in parameter, but I always get error:</p>
  
  <blockquote>
    <p>An error has occurred during report processing. (rsProcessingAborted)
    The property ‘ValidValues’ of report parameter ‘STARTDATE’ doesn't
    have the expected type. (rsParameterPropertyTypeMismatch)</p>
  </blockquote>
  
  <p>When I just passing result of query (date format), I have list:</p>
  
  <p><a href="https://i.stack.imgur.com/kq8cA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kq8cA.png" alt="enter image description here"></a></p>
  
  <p>even If chose Date/Time:</p>
  
  <p><a href="https://i.stack.imgur.com/xaFoj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xaFoj.png" alt="enter image description here"></a></p>