Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Coding, syntax & commands
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only