Creating a date range formula

on your select criteria,
 {date.field} in {?Startdate} to {?endDate}

?startdate
?enddate is your parameter

create your paramters to be datetime

without parameter:
 on your select expert click new then choose your date.field
choose the is between and choose your start date and end date
date.jpg

If you simply want to always run from 4 pm yesterday to 2 am today, then you can use this logic in your record selection formula:

{table.datetimefield} in datetime(currentdate-1,time(16,0,0)) to datetime(currentdate,time(2,0,0))

I guess I should have refreshed the page before posting.  

mlmcc, I guess we had the exact same solution.

Except I had the times screwed up...

Thanks for all your help....it worked perfectly