Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date Conversion Problem in Excel to VF....
Message
 
 
À
30/05/2002 10:36:23
N. Lea
Nic Cross Enterprises
Valencia, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00662945
Message ID:
00663010
Vues:
24
>>>
>>>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform