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
Diane Robitaille eng.