Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SPT with date criteria
Message
From
27/09/2005 11:24:03
Steven Dyke
Safran Seats USA
Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using SPT with date criteria
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01053462
Message ID:
01053462
Views:
56
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.
Next
Reply
Map
View

Click here to load this message in the networking platform