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:
but it didn't work....
the field DateOrder is of DateTime type...
any ideas?
(-:
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?
(-: