Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace Date field with Character value
Message
De
04/10/1999 13:41:14
 
 
À
04/10/1999 13:17:54
Jolene Dicks
Human Resources Development Canada
St. John's, Terre-Neuve, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00272313
Message ID:
00272395
Vues:
32
>This is my code below:
>
>Tmp="19650824"
>a=Right(Tmp,4)
>b=Left(Tmp,2)
>DateString=(Left(Tmp,4)+"\"+b+"\"+Right(Tmp,2))
>
>Tmp2=CTOD(DateString)
>Replace Client.DOB with Tmp2
>
>It just isn't working for me. It is replace client.dob with {\\}!! Any suggestions?

In addition to what George has said, don't you really mean:

b=LEFT(a,2)

???

Otherwise you're creating a date string like "1965/19/24" which is invalid.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform