Malformed If Statement

[CRogers22]

I'm trying to create an IF statement to tell me if there is >= 3 days between dates. Can someone tell me what I'm doing wrong?

if [Application Date]-[Disclosure Date]>=3 then 'Pass' else 'Fail'

[binu_acs]

@CRogers22 

IIF DateTimeDiff([Disclosure Date], [Application Date],'Days') >= 3, 'Pass','Fail')

[CRogers22]

Thank you. Now I'm getting Unknown variable "IIF"

[binu_acs · Accepted solution]

put a bracket after IIF

updated the formula

IIF(DateTimeDiff([Disclosure Date], [Application Date],'Days') >= 3, 'Pass','Fail')

[LindonB]

Hi there. First, just add a select tool first to make sure both fields are numeric. If so, your expression is fine but needs "ENDIF" at the end. It won't work otherwise. 

if [Application Date]-[Disclosure Date]>=3 then 'Pass' else 'Fail' endif