General information
Category:
Coding, syntax & commands
>>>>isblank(ctod(allt(.Text1.Value)))
>>>>
>>>>this will return .T. if the date invalid ( according to VFP ).
>>>>
>>>>- jer
>>>
>>>But if the date is valid, this gives an error.
>>
>>what version are you running...I just tried to make this through and error and is wouldn't.
>>
>>isblank(ctod(allt("2001/12/02"))) = .T.
>>isblank(ctod(allt("02/12/2001"))) = .F.
>>isblank(ctod(allt("blablablaa"))) = .T.
>>isblank(ctod(allt("06-12-2001"))) = .F.
>>isblank(ctod(allt("06-45-2001"))) = .T.
>
>The problem lies in the fact that if the date is valid, the value of the textbox will be a date type. So it's like doing isblank(ctod(allt({06/05/2001}))), which gives an error.
why would .value = {06/05/2001} ? I'm not familiar with a condition that would do that, althought I don't use this when the textbix is bound - that may be why in your case. if so might what to add
if vartype( form.textbox.value ) <> "D"
isblank(...
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