Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date type
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01644735
Message ID:
01644739
Vues:
72
>I am just about completing a fairly extensive import utility of CSV files, and have a potential concern about this type of date found as a character (I was thinking there was a built in VFP way to make this conversion, but can't remember what it was) :
>
>December 12, 2016 or Dec. 12, 2016
>
>If I allow a user to select the above as a Date field, I need to convert it to a normal 12/12/2016 which is stored as a date field in the table. Anyone know the best way to do this? I will not know ahead how the date is stored and will be testing it before appending it to the actual date field in the table.

FoxPro would not recognize it as a date. You will have to roll out your own conversion
Something like (pseudo code)

lnItems = ALINES(laItems, lcDate, [,])

IF lnItems = 3
AND laItems[1] LIKE < One of Month >
AND VAL(laItems[2]) BETWEEN 1 and 31
AND VAL(laItems[3]) BETWEEN 2000 AND 2099
*It maybe a date
ELSE
* bummer
END


--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform