Quick Question About The DateAdd() function in Access 2000

[Shawnm]

I'm working on a query and I want all records that were created within the previous 12 hours, however when I use >=DateAdd("d",-(1/2),Date()) at 9AM for example, it will not show any records from before midnight, so it isn't very helpful if I try and use it early such as 4AM, because I lose 8 hours worth of Data? Does anyone know a query criteria that will just give em the previous 12 hours?

Thanks.

 

[Shawnm]

Nevermind. I can use >=(Now()-(1/2)).