Is it possible to write a formula for if a Date field is not null upon record insertion?

I would prefer to not write a trigger for this.


Record Example A --> Field XYZ is null --> Formula evaluates to False.

Record Example B --> Field XYZ is 2016-04-25 --> Formula evaluates to True.


1 Answer 1


It's pretty simple, you just need to negate the results of the ISBLANK function. You can also detect insert with ISNEW.

AND(ISNEW(), NOT(ISBLANK(My_Date_Field__c)))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .