>I put that in, But I'm getting a error expression invalid.
>
>Kelly
Oh sorry I didn't evaluate the expression if a valid one.
IIF(ticketdata.loandate - (date()-loandate) > 90,.T.,.F.)
The above is not valie because it returns data type mismatched.
(date()-loandate) returns numeric and we can not minus it to another date type.
Why not adding a numeric field? And make use of it as the criteria for checking: Iif(ticketdata.loandays > 90, .T.,.F.). Or a logical field which will be turned to .T. if it meets the condition.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."