General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Append From Excel file with a date field
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only