Forum Discussion
Convert boolean value using Value function
Hi johnt75 , I have corrected it to &&, still getting the same error
If the exception column is a true/false type, which it looks like it is, then I don't think you need the VALUE function. You should just be able to compare the exception column to TRUE().
Thanks johnt75 , this worked. But still don't know how. Because we didn't convert the Boolean type to text and compared it to text value
Hi johnt75 , I have corrected it to &&, still getting the same error
If the exception column is a true/false type, which it looks like it is, then I don't think you need the VALUE function. You should just be able to compare the exception column to TRUE().
Thanks johnt75 , this worked. But still don't know how. Because we didn't convert the Boolean type to text and compared it to text value
I think its because VALUE expects a text value and you were passing in a boolean. The error message could be phrased better.