Date - Data type mismatch in criteria expression in Access
<p>I have a table which stores birthdate in the field <code>DateValueOf</code>. I am creating a query where user can input any date and the query will return customers which have birthday on that day.</p>

<p>For this, I am trying to convert all  the year in <code>DateValueOf</code> to current year.</p>

<pre><code>eg &gt; #13-10-1996# to #13-10-2016#
eg &gt; #13-10-2001# to #13-10-2016#
</code></pre>

<p>So that I will then ask user to select date from date picker and run the below query.</p>

<pre><code>SELECT CustomerID 
WHERE FormatDateTime(DateValue(DateSerial(Year(Date()),Month([DateValueOf]),Day([DateValueOf]))),2) &gt;= #13-10-2016#
</code></pre>

<blockquote>
  <p>But this SQL statement produces an error <code>data type mismatch in criteria expression</code> </p>
</blockquote>

<p>Please highlight my mistake. Thanks in advance. I am also open to any other way to get who's birthday it is today.</p>