Henry
You have to convert the TmpData.date1 column to a character.
iif(TmpData.SortKey = "6", TmpData.Descr+" "+transform(TmpData.Date1), TmpData.Descr)
>Hi Cathy:
>
>Here is an expression I used in the report for a field. The idea here is to evaluate whether the SortKey is for Consultations. If so, then print both the description and the Date Referred (Date1), else, just print the Descr field.
>
>
iif(TmpData.SortKey = "6", TmpData.Descr+" "+TmpData.Date1, TmpData.Descr)
>
>However, I get a "Operator/operand type mismatch". Wondering if the concats of the Descr and the Date1 fields is causing the problem. If so, how do I get the Date Referred also to print for consults?
>
>Thanks Cathy.