sory for the wrong example...
Select table1.RptDate, table1.RptNo From table1 WHERE table1.RptDate = '27/04/2004'
Gustav Brock wrote:
Hi Elvin
Could very well be so ... April has 30 days only.
/gustav
I.m using VB, Cache 4.1 and odbc
I have put in the following sql code but it doesn't return the intended result.
sql code:=
Select table1.RptDate, table1.RptNo From table1 WHERE table1.RptDate = '31/04/2004'
or
Select table1.RptDate, table1.RptNo From table1 WHERE table1.RptDate = '04/31/2004'
both of the above return no result.....
