Selecting Hour -1 1

[scottyjohn]

Hi all,
I am using the query below to query a back end oracle view from an access front end.

SELECT SOFTPHONE.*
FROM SOFTPHONE
WHERE STARTD=Format(Now(),'dd/mm/yyyy')
and left(startt,2)=Format(Now(),'HH');

It works fine for current date, current hour, but I need to adapt the query to select current hour -1, but cant seem to get the syntax right. Can anyone point me in the right direction?

John

 

[Golom]

and left(startt,2)=Format([red]DateDiff("h",-1,Now())[/red],'HH');

 

[Golom]

Sorry ... too early in the morning

and left(startt,2)=Format([red]DateAdd("h",-1,Now())[/red],'HH');

 

[scottyjohn]

Thanks Golom, that worked perfectly!

John