Hi!

How can I use the value of date field inside of a string whose content is a selec statement? Something like this.

cdate=dtoc(table2.date)
cSelect="selec * from table where table.date<="+cdate
&cSelect

TIA