hi. i was wondering how i would set a time range so that the DBatch.start field will display a range from 6PM yesterday or tuesday(any weekday) to 5:59PM the next day i.e. today/wednesday. Here's what i have: SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end, DBatch.duration, DBatch.recordcount FROM DBatch WHERE ???? ORDER BY DBatch.start; Both the DBatch.start and the DBatch.end fields are in the Date/Time format. Thanks.