Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date Conversion Problem in Excel to VF....
Message
 
 
To
30/05/2002 10:36:23
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00662945
Message ID:
00663010
Views:
25
>>>
>>>Or a method to convert the numeric value of a date into a date form.
>>
>>Take a look at XL8 import Message #655336. It shows how to convert serialized number into the date.
>
>I looked at it, and correct me if I am wrong (which I probably am), but it looks to me that I would take any numeric number that Excel produced when it transformed the date into a numeric or character. Then I would take the number and add it to the date of (^1899-12-30} to get the actual date it use to be?

Excel stores dates as serialized numbers internaly. That's the reason you get those numbers instead of expected dates. Adding Excel serialized numbers to the (^1899-12-30} date constant will convert them to the VFP date format.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform