Greater than / Less than date/time table expression
<p>I have the following expression in a MS-access table:</p>

<p><code>IIf([End Date/Time]&gt;="12/8/2016 6:00:00",1,0)</code></p>

<p><code>12/08/2016 18:15:00</code> will return a '1', however 
<code>12/08/2016 14:23:29</code> returns a '0'</p>

<p>I'm assuming this is an issue with AM/PM.  I tried putting '6:00:00 AM' in my expression but no change.</p>

<p>Also I would like to replace '12/8/2016' with 'yesterday' but <code>date()-1</code> doesn't seem to be working.</p>

<p>EDIT: I figured out that the time needs to be '06:00:00'.  That yield the correct dates.   Still don't know how to get this automatically (ie yesterday at 06:00)</p>

<p>Thanks</p>