Time difference criteria in Query

[matpj]

I have a query that returns all records with Status NOT EQUAL 'closed'.

In this query I have a Date field of the format 'dd/mm/yyyy hh:mm:ss'.

I want to add a criteria that will display all records where Status IS NOT EQUAL 'Closed' AND current system date/time IS MORE THAN 3 hours greater than the Date field.

how is this possible?
any help will be appreciated!

Matthew

 

[tlbroadbent]

Add the following critera.

[date]<dateadd(&quot;h&quot;,-3,now())

Dateadd adds -3 hours to current time. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[balor]

Use DateAdd. Add 3 hours to the systemtime and compere.

[Date field] > DateAdd(&quot;h&quot;,3,Now())