+ 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.