Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select date ranges 1

Status
Not open for further replies.

stakadush

Programmer
Oct 1, 2001
195
IL
hello
i want to get all the orders from the table by order date.
for example, i'd like to get all the orders that were submitted before and including january 2004.
i was trying the query:

Code:
SELECT * FROM OrdersWebHost WHERE DateOrder<='2004-01';

but it didn't work....
the field DateOrder is of DateTime type...
any ideas?

(-:
 
ofcourse....i guess i just worked too much today! :) hehehe...works like charm...
thanks a lot...

(-:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top