* Our Dev Team just migrated completely to Microsoft Development. I am very much "getting started" with VSTS2008, TFS, and C#.
I am attempting to query all records between Now (whatever time it is now) and yesterday at midnight. I have built the query below which does get those records:
SELECT DISTINCT JCA_Number, Date_Order
FROM Orders2
WHERE (Date_Order >= DATEADD(d, - 1, GETDATE()))
However, the query only pulls records between Now [9/21/2009 2:21:24 PM] and 9/20/2009 2:21:24 PM
The problem I'm having is I can't figure out how to get records Now [9/21/2009] and 9/20/2009 *12:00:00 AM*
I have been searching this site, bing and google for an hour. Any assitance is wonderfully appreciated. Who knew something so simple could frustrate so much.
Cheers
Ian
...
Go to the complete details ...