try Select table1.RptDate, table1.RptNo From table1 WHERE table1.RptDate = #04/27/2004#
"Elvin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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..... > > > > >
