What date format should I use for 'OrderDate' field in Sql quries?

[sai1234ram]

Dear Team
I am working with Sage MAS90 version 4.2.
I am retriving the datas from "SO_SalesOrderHeader" table.
Here I have given my query string
Sqlqry= "Select ItemCode,ItemCodeDesc,OrderDate,OrderType from SO_SalesOrderHeader where OrderDate='3/31/2008'". for that query I am getting the error as "ERROR [S0000] [ProvideX][ODBC Driver]Invalid operand for operator: ="
I think the Date format which I am giving is wrong.

Can anyone tell me which format is to be used.
Regards
Kaliprasanna

 

[BigLouie]

Write a Crystal report based on the table and with that selection and then go look at the SQL statement. That will tell you how to write it.

 

[dfeller]

Your query doesn't make sense. ItemCode is not in the SO_SalesOrderHeader table.

Dawn

 

[BigLouie]

Kaliprasanna where are you located?

 

[strtech]

SQL uses the "yyyy-mm-dd" format. You should change it to:

WHERE SalesOrderDate <={d'2008-03-31'}.