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