Hey I'm running sql server & inside my where clause I have about 6 of these conditions for different date ranges. The dateadd functions work great, maybe too good in my case. I am missing records because inside the DB if the record has a timestamp for prior than the current time I am running it doesn't get caught. Can I specify my date range (27-33) days and say starting at 12 o clock a.m today instead of the current time? 

i.e: A record belonging to March 11, 2014 meets the 27 day range. But it's actually inside DB as

March 11, 2014 4:00:00 Which wont get retrieved bc it's after 4 am.

```
+ "where "
+ "(b.new_SwWarrantyEndDate >= dateadd(day,27,(CONVERT (date, SYSUTCDATETIME()))) AND "
+ "b.new_SwWarrantyEndDate <= dateadd(day,33,(CONVERT (date, SYSUTCDATETIME())))) OR "

```