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
cj@sflcj@sfl 

A Date Forumla Field

Hi,
 
I'm trying to set up a custom formula field. I want it to take the date value from one field and if that doesn't exist to take a date value from another field.
 
The formula I have is as follows...
 
IF(  LastCUUpdateDate = null  ,   Manual_KIT_Save_Date__c  ,   LastCUUpdateDate)
 
Any ideas where I'm going wrong?
 
Cheers,
 
Colin
Vijay RautVijay Raut

Hi Colin,

Instead of using LastCUUpdateDate = null  you can use ISNULL function and also make sure that fields used in this having same Data Type.

You can use following:

IF( ISNULL( Date_Test__c ), TODAY(), Date_Test__c )

Regards

Vijay Raut
cj@sflcj@sfl

Hi Vijay,

That's worked exactly how I wanted it to. Thanks for all your help!!

Cheers,

Colin:smileywink: