Diaply last 4 hrs of data in a Query

[omer123456]

Hi,



I have a table with data in it....we collect data every hour so on any given day we can have 24 time stamps.

Field name: Date:
Data Type: Date/Time

I am trying to build a Query from that table, where the "Criteria" for the "Date:" is to display only last 4 hours of data

What should I use as my criteria

Thanks
Omer

[Welshgasman]

Use DateAdd()

[ArviLaanemets]

As start, change the field name Date to something different, as Date is reserved as the name of Date function!

The criteria for your query must be (on fly) something like '... WHERE NOW() - YourDate < 5/12 ...'
(4/12 does match for 4 hours, but the last time stamp may be up to hour earlier - so <5/12 (NB! Not <=5/12!) must always include 4 last timestamps)

[omer123456]

This is giving me a syntax error DateAdd()


Thx

[omer123456]

I googled & it gave me this...... [DATE:]>=Now()-5/12, but when I enter it in the criteria field in a query it becomes [DATE:]>=Now()-#5/12/2025#

Somehow its taking 5/12....last 5 hrs out of 12 and converting it to a date

Thanks

[madpiet]

SELECT Orders.OrderDate
FROM Orders
WHERE Orders.OrderDate > DateAdd("h",-4,Now())

[Welshgasman]

This is giving me a syntax error DateAdd()


Thx

You cannot even be bothered to lookup the syntax?

[June7]

Try:

SELECT TOP 4 [ID], tablename.* FROM tablename ORDER BY [Date] DESC;

[omer123456]

Thanks for your smart comment. If I knew what I was looking for, I wouldn't have asked.

Did you test it before posting?

Thanks anyway

[Welshgasman]

Thanks for your smart comment. If I knew what I was looking for, I wouldn't have asked.

Did you test it before posting?

Thanks anyway

It is a function.? You need to give it your specific parameters so it returns what you want?
Did you think it was miraculously going to know what those were?
@June7's offering is the easiest for the last 4 entries anyway, whether they are within the last 4 hours or not.

[madpiet]

I'd be careful biting the hand that feeds you. =(

if you use the wizard when you're doing this kind of thing, it'll help you build the expression. Go into the query in design view, then click on the Builder button then click on Functions > Built-in Functions > Date/Time > DateAdd

and it'll show the syntax:
DateAdd(«interval», «number», «date»)

[jojowhite]

Last 4 hours of the Latest date entry, or last 4 hours of each Date entry?

[ArviLaanemets]

I googled & it gave me this...... [DATE:]>=Now()-5/12, but when I enter it in the criteria field in a query it becomes [DATE:]>=Now()-#5/12/2025#

Somehow its taking 5/12....last 5 hrs out of 12 and converting it to a date

It's morning for me now, so I could test it.
Somehow I managed to use 12 hours in day instead of 24 in my late hours yesterday And probably it would be wise to use the syntax ACCESS cant be too helpfull with too. The condition below worked for me!

SELECT * FROM tblTest WHERE TSTime+4/24>NOW;

[omer123456]

Thanks, I am not biting anyone. I appreciate anyone's help.

I am new to this & learning; Experts need to realize that too..... Maybe it's easy for you guys, but I am new

Thanks for everyone's help !!!!

[June7]

Did you see post #8?

Welshgasman only suggesting you learn to help yourself. You were provided an intrinsic Access function to use, instead of just coming back with "I don't know what that is", make some effort to find out for yourself. Starting with Microsoft documentation. https://support.microsoft.com/en-us/...9-79b17dcd0df1