Can't get the Today() function to work properly in MS Access 2016 Custom Web App
<p>I'm trying to setup a query that will show me all of the records in a particular table where the listed expiry date is either in the past or upcoming in the next 6 months (approximately).</p>

<p>At the moment, I have the "Expiry" field added to my query and the 'Criteria' as .</p>

<p>When I try to save the query, I get the following message:</p>

<blockquote>
  <p>Access can't evaluate an expression or convert data because data types aren't compatible with each other.</p>
  
  <p>TECHNICAL DETAILS</p>
  
  <p>Correlation ID: ae68949d-3041-3000-0984-71635f8fd670</p>
  
  <p>Date and Time: 7/28/2016 6:54:34 PM</p>
</blockquote>

<p>I've tried searching the web for a solution, but most websites refer to the Date() function that doesn't seem to be available in the Access 2016 Custom Web App. When I take out the "+180", it works fine but obviously doesn't give me what I need.</p>

<p>Any help would be appreciated.</p>

<p>=============================</p>

<p>UPDATE:
Some users have asked for my SQL and Table Design details. I don't seem to have any way of accessing the SQL View (the option doesn't appear), but here's a copy of my table view:
<a href="http://i.stack.imgur.com/UVh5i.jpg" rel="nofollow">Access Query Table Design</a></p>

<p>In the table, 'Active' is a Yes/No field and 'Expiry' is Date/Time.</p>