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.


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)))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.