Simple IF statement returning wrong results.

Question

Hello and thank you in advance for your time.

I'm running a simple IF Statement

IF [Days 1]<='30' Then 'Pass'
Else 'Fail' ENDIF

But in the results its showing 7 , 9 days etc., as a fail. Then in some cases it's retuning the correct result and all the fails are returning the correct results.

any ideas what I'm doing wrong?

Thanks again

binu_acs · Accepted Answer

@CRogers22  to Number([Days 1]) <= 30 Then 'Pass' Else 'Fail' EndIf

7 and 9 are less than 30 which is correct as per your logic

LindonB · Accepted Answer

If [Days 1] is a string, then use this....
IF ToNumber([Days 1])<=30 Then 'Pass'
Else 'Fail' ENDIF

If it is a numeric value, use this....

IF [Days 1]<=30 Then 'Pass'
Else 'Fail' ENDIF