I need a formula that finds a departure date between two given dates where the departure occurs later than a given time
<p>Im using Access 365 2016.</p>

<p>I need a formula that finds a departure date between two given dates where the departure occurs later than a given time.</p>

<p>I have tried this formula but it doesnt work:</p>

<pre><code>Between [date1] And [date2] Where (TimeValue([Date1] &gt; 09:30
</code></pre>

<p>Thank you</p>

<p>The formula i quoted above is a simpler way of writing the formula that references controls on my form. </p>

<p>The formula below references controls in my Flights form and is the exact formula that I used in the expression builder. </p>

<pre><code>Between [Forms]![Flights]![cboDeparture]

    And

    [Forms]![Flights]![cboDeparture2]

    And

    TimeValue([Forms]![Flights]![cboDeparture])&gt;[Forms]![Flights]![cboGreaterThanTime])
</code></pre>

<p>I altered the formula according to the code provided by Gustav in the comments section but neither code worked. See comments.
This is the code that I used for <strong>Method 1:</strong></p>

<pre><code>    (Between [Forms]![Flights]![cboDeparture] 
And [Forms]![Flights]![cboDeparture2]) 
And (TimeValue([Forms]![Flights]![cboDeparture])&gt;[Forms]![Flights]![cboGreaterThanTi‌​me])
</code></pre>

<p>This is the code that I used for <strong>Method 2:</strong></p>

<pre><code>    Between (DateValue([Forms]![Flights]![cboDeparture])+#09:30:00#) 
And [Forms]![Flights]![cboDeparture2]
</code></pre>