Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Text to Date, but conditionally
Message
From
31/08/2008 13:28:42
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01343648
Message ID:
01343654
Views:
18
>>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform