function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
rossjohnson87rossjohnson87 

Trying to create a greater than 'null' field...need some assistance

Hey guys, I'm an intern building a database for a real estate company and need some serious help.  I'm trying to create a field (specifically a date field) that when a date is added to the field, it triggers the next set of tasks.

 

Currently I have selected:

 

Eviction Scheduled (date field) is 'not equal to' ""

 

It isn't accepting "" as a null value so first wondering what null is in Salesforce's language.

 

 

When that didn't work I tried to create a formula that triggered when any date beyond May 1st, 2009 was entered (and was true).  No luck there either.

 

This was the formula:

 

REOHQ__REOHQ_Eviction_Scheduled__c > DATE(2009,5,1)

 

 

 

If anyone has any advice, I would be greatly appreciative of some help.

 

 

Thank you,

 

Ross Johnson 

 

NPMNPM

Take a look at ISNULL in Help and Training.

 

Empty date and date/time fields always return true when referenced in ISNULL functions.