Hi,

I usually convert my dates into a character string, SQL handles them nicely.

Something like this:

lcDateStart = "'20040101'" && use yyyymmdd format
lcDateEnd = "'20040515'"

SQLEXEC(tConnection, 'SELECT * FROM LineCall ;
where datecreated >= ?lcDateStart ;
and datecreated <= ?lcDateEnd ', 'cuLineCall' )



HTH