+ Start a Discussion
morleymorley 

Inconsistent error with ISNULL?

Hi there ... I'm completely confused by this.

I have two Salesforce accounts: one Dev Edition, one Enterprise Edition, both on Spring 07. I have a formula field (return type of text) on a custom object in the Dev Edition with this formula:


if ( isnull(  Order_Date__c  ) , "Y", "N" )

 

... and it works fine. But if I do exactly the same thing in my Enterprise Edition I get a syntax error: "Error: Incorrect argument type for function isnull()."

I've tried substituting other fields into the ISNULL() function and it seems that standard fields work fine, but custom fields give this error.

How could this be?

Thanks for any help.

 

Glenn.