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!