Need Help

[paulwalker]

HI Community,

In  my text box i have used CONCAT function.

=Concat( if(($(vVariable)>=Date-10)  and ($(vVariable)<=Date-5), EmpID),  ',')

This expression working fine, but i want to show distinct values in my TextBox...

Thanks in Advance..............

[sunny_talwar · Accepted solution]

Use DISTINCT then

=Concat(DISTINCT if(($(vVariable)>=Date-10)  and ($(vVariable)<=Date-5), EmpID),  ',')

[paulwalker]

Actually i have tried DISTINCT, It was throw Expression Error...

i don't know what happend.... now it's working....

[sunny_talwar]

Great

Would you mind closing this thread by marking the correct answer.

Best,

Sunny