Only view data from two hours ago til now.

[MFS]

Hello all, June7 helped me with this a few weeks ago but I still seem to be having a few issues with it.
I'm looking to only review data from two hours ago until now. By saying this if only a few data points came in today and they were only 15 minutes old I would like to see it. With the below code it does not show any data unless I have data up to the two hour requested.
Also, my time format in the database is HH:mm and my computer is set for hh:mm, this is also causing problems. (Example shows data at 14:00 and 2:00, twelve hours difference from each other. Again only wanting to see previous two hours)


Basically saying, is there another alternative to June7's code?

WHERE (((dbo_turntable41.device)=2) AND (([date1] & " " & [timeatcatcher]) Between DateAdd("h",-2,Now()) And Now()));

[June7]

I did some more testing. Apparently not enough just to concatenate the date/time, use CDate() function as well.

CDate([date1] & " " & [timeatcatcher)

[MFS]

Once again, I am so glad you are on this forum. Works perfectly, thanks again June7