Hello,

I'm trying to work within the expression editor in ZOHO Creator. I have a field that currently is populated to say Valid or Expired depending on whether or not the date is after the current date. That looks like this,

IF(NCIC_Expiration_Date > zoho.currentdate,"Valid","Expired") 

I'm trying to get the same field to show "MISSING" if the field is left blank. I tried to write an expression like this,

IF(NCIC_Expiration_Date > zoho.currentdate,"Valid","Expired") ifnull(NCIC_Expiration_Date, "MISSING")

But I believe it is horribly wrong and shows syntax errors. Can someone help to resolve this?

Thanks!