General information
Category:
Coding, syntax & commands
>>>>Can anyone tell me why the following code used to work (under VFP50) and now, all of a sudden, gives me an error message "Operator/operandi mismatch" ? The underlying field is formatted for datetime and I haven't changed anything else (that I'm aware of) to cause this sudden refusal to work syndrome! Century is set on. Thanks in advance.
>>>>
>>>>IF !EMPTY(THIS.Value) < DATETIME()
>>>> = MESSAGEBOX("You need to enter a VALID date or time",1,"ERROR MESSAGE")
>>>> RETURN .F.
>>>> ELSE
>>>> RETURN .T.
>>>>ENDIF
>>>
>>>It's not related to the field but to This.Value.
>>Does that mean that I need the Character to Date converter as in
>>IF !EMPTY(CTOT(This.value) < DATETIME() ???
>>I really need to validate this data.
>>
>>Thanks - Linda
>
>You need 2 tests:
>
>
>If EMPTY(This.value))
> * Your message here
> return .f.
>endif
>if This.value > datetime()
> * Your message here
> return .f.
>endif
>return .t.
>
>
>Vlad
Thanks All . . I'll bet I did add that !Empty() after. Thanks for the advice and two part valid check code, Vlad.
Linda
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