Query for Past 12 Hours

[esh112288]

I'm trying to write a Query to pull all records added in the last 12 hours from the NOW() date and time stamp but nothing that I've tried is working. Suggestions?



I currently have:

 Between Hour(Now()) - 12 and Hour (Now())

[pbaldy]

I think you'd want:

Between DateAdd(...) And Now()

where the DateAdd() function would subtract 12 hours from now.