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.