title: Access built-in functions like Year() and Date() are not recognized
body: <p>I tried the simple query:</p>
  
  <p><code>select Year ( #5/1/1990# );</code></p>
  
  <p>It shows error dialog:</p>
  
  <blockquote>
    <p>Not defined function <em>"Year"</em> in expression</p>
  </blockquote>
  
  <p>Also, when I use <code>Date()</code> in the form it shows <code>#NAME</code>. I added it with expression builder in Access. What am I doing wrong?</p>