Time trouble

[wh00t]

I'm having a touch of trouble extracting some information from a table.

I have a field which contains date and time (set by using Now())

and I wish to extract information using this field with a time < 12 hours of current time

any advice greatly appreciated

 

[simongallop]

>dateadd("h",-12,now())

HTH