Thanks, thats it.
Jerry
>see
>
Re: Importing Excel Files - Date Problem Thread #
548892 Message #
548906>
>>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