Invalide Type in Operator

[AC3]

I'm getting a "Invalid type in operator >=" when trying to create a simple condition

iif([Right_u_start]>=[u_start]&&[Right_u_start]<=[u_end_date],"True","False")

[Thableaus · Accepted solution]

Hi @AC3 

You need to check for data types. Fields can be only compared if they have same data types (string, numeric, dates, etc.)

Cheers,

[MarqueeCrew]

@AC3 ,

If the variable that you're trying to put "True" or "False" into is a numeric type, you'll see this.

Cheers,

Mark