>I am trying to use SPT to get a result set based on greater than a date.
>
>The remote table is an AS400 file which stores a date(vacsdate) as 2005-12-01.
>
>I want my SPT select statement to use Where vacsdate > myDate. a SPT select on the entire file displays the date in a normal format, so I know VFP can interpret the AS400 date.

m.CheckDate = date()
SQLExec(m.lnHandle,"select * from myTable where vacsdate > ?m.CheckDate","myResult")

Cetin