Elvin wrote: > SELECT table1.RptDate, table1.RptNo FROM table1 WHERE table1.RptDate = > '27/04/2004'
The most obvious question is whether there are any entries with the specified date. Surely you used $H format for the dates. IIrc, that means that you need WHERE $zd(:rptdate)="04/27/2004" ($zd() take a format parameter that you can use to get the format you wish). My other question is what is the purpose of the "table1." prefixes? This is SQL not an object query language.
