Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert Text to Date, but conditionally
Message
De
31/08/2008 13:28:42
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01343648
Message ID:
01343654
Vues:
21
>>Ok, so...
>>
>>IIF(EMPTY(CTOT(TRANSFORM(cValue),'@R ^99/99/99T99:99:99'))),cValue,CTOT(TRANSFORM(cValue),'@R ^99/99/99T99:99:99')))
>>
>>I guess I was trying not to add the conditinal overhead to every value in the detail line in the report, but now that I think about it, there really is no other way.
>
>
>You cold use Dynamics in the report, but for that you should redistribute all REPORT*.APP to your clients.

You know, that solution is not going to work for me. A zip code just evaluated to a date of 10/01/03 and the EMPTY() would not catch that. Numerics are going to be a problem. I do not know the type of cValue, so how can I make sure I only convert valid dates to dates?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform