Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Text to Date, but conditionally
Message
From
31/08/2008 13:45:50
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:
01343656
Views:
20
>>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?
>
>You can use an UDF.

That's great, but I'm still left with the issue of being able to tell if a number is not a date if it satisfies the !EMPTY() of the value. If the number converts to a seemingly good date, then I'm out of luck. I have to know whether it is a date beforehand. I think I have to work this from another angle.
Previous
Reply
Map
View

Click here to load this message in the networking platform