Can you Format a Query Definition on a Date/Time Field to get just the last day not the last 24 hrs.

4023
0
01-28-2015 01:27 PM
ShaneLim
Occasional Contributor

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?

Shane

0 Kudos
0 Replies