Taking Time from Now() Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to setup a query that will return all data that has been created 1
hour ago.

In the data input form there is a filed that ask for todays date, when i run
the query i want to find all dates that were entered into this field 1 hour
aga from Now().

How would i setup this in a query (if possible at all).

Thanks..Anymore info need please let me know.
Paul
 
pgilbert11 said:
I'm trying to setup a query that will return all data that has been
created 1 hour ago.

In the data input form there is a filed that ask for todays date,
when i run the query i want to find all dates that were entered into
this field 1 hour aga from Now().

How would i setup this in a query (if possible at all).

Thanks..Anymore info need please let me know.
Paul
Click to expand...

SELECT *
FROM TableName
WHERE [DateField] > DateAdd("H", -1, Now())
 
Thanks Rick

Rick Brandt said:
pgilbert11 said:
I'm trying to setup a query that will return all data that has been
created 1 hour ago.

In the data input form there is a filed that ask for todays date,
when i run the query i want to find all dates that were entered into
this field 1 hour aga from Now().

How would i setup this in a query (if possible at all).

Thanks..Anymore info need please let me know.
Paul
Click to expand...

SELECT *
FROM TableName
WHERE [DateField] > DateAdd("H", -1, Now())
Click to expand...
 
Back
Top