NULL Query

[ZachUnger]

Hi Team 

I'm working on the below query and cannot get the null function to produce the required result 

Permit Status =
IF(required[ExpiryDate] <= TODAY(), "Expired",
IF(required[ExpiryDate >= TODAY(), "Current",
IF(required[ExpiryDate=null, "Not Defined",)))

Can somebody please help with this?? 

Cheers

z 

[wdx223_Daniel · Accepted solution]

Permit Status =

IF(ISBLANK(required[ExpiryDate]), "Not Defined",
IF(required[ExpiryDate] <= TODAY(), "Expired",
"Current"))

[ZachUnger]

Thanking you 🙂