Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs. When I do a query that says.
FinishDateTime Is within the last 1 days
I get the last the 24 hours. I need to get it to stop at midnight. Any ideas?