StartDate = thisform.fromdate.value
EndDate = thisform.todate.value

TEXT TO cVar NOSHOW TEXTMERGE
   SELECT CAST(RTRIM(charfield) AS char(10)) AS charfld,
      <<m.StartDate>> AS StartDate, <<m.EndDate>> as EndDate
   FROM myTable
   LEFT JOIN ...
   WHERE ...
      AND fld_EntryDate >= <<m.StartDate>>
      AND fld_EntryDate <= <<m.EndDate>>
   ORDER BY ...
ENDTEXT

SQLEXEC(nHndl, cVar, "curname")