function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ccgormanccgorman 

Set a date field to blank through a CASE/IF formula

How can I set a date field to blank/null when using a Case/If statement?

 

IF (Due__c = True,  TODAY() + 7,Due_Date__c = ????)

 

Best Answer chosen by Admin (Salesforce Developers) 
cvuyyurucvuyyuru

try this

 

 

IF (Due__c = True,  TODAY() + 7,null)

All Answers

cvuyyurucvuyyuru

try this

 

 

IF (Due__c = True,  TODAY() + 7,null)

This was selected as the best answer
ccgormanccgorman

Thank you.  Worked perfectly.  The key is exactly like you wrote, no quotes around null.