Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From Excel file with a date field
Message
From
04/08/2003 16:33:14
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Append From Excel file with a date field
Miscellaneous
Thread ID:
00816630
Message ID:
00816630
Views:
79
I'm using VFP8 to Append From an XLS file. This Excel file has a date field formatted as:

August 4, 2003

I create a VFP import cursor and import as follows:
CREATE CURSOR cimport ( mydate C(20) )
APPEND FROM myxls.xls TYPE XL8

This works except that the date column in my cursor displays as
37837 (todays date), instead of August 4, 2003.

Is there a function to convert this date format into a VFP format?

Thanks,

Jerry
Next
Reply
Map
View

Click here to load this message in the networking platform