Taking Time from Now() Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pgilbert11 - 07 Sep 2006 11:08 GMT

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

Reply to this Message

Rick Brandt - 07 Sep 2006 12:28 GMT

> I'm trying to setup a query that will return all data that has been
> created 1 hour ago.
[quoted text clipped - 7 lines]
> Thanks..Anymore info need please let me know.
> Paul

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

pgilbert11 - 07 Sep 2006 13:37 GMT

Thanks Rick

> > I'm trying to setup a query that will return all data that has been
> > created 1 hour ago.
[quoted text clipped - 11 lines]
> FROM TableName
> WHERE [DateField] > DateAdd("H", -1, Now())

Reply to this Message