Ask Search:
Kristen TranchidaKristen Tranchida 

Formula Field for Date

Hello,

I'm creating a formula field called "First Contact Date". If a field called "Custom Created Date" is populated (data from our CRM migration a few months ago) I'd like the field to show that date. If there is not data in that field (i.e. a lead has been created post-migration) then I'd like to it populate with Salesforce's "Created Date" field.

I've been working with the BLANKVALUE and IF operators and unsure if I'm on the right track. Thanks!
Best Answer chosen by Kristen Tranchida
Deepak AnandDeepak Anand
Like this = 
BLANKVALUE(Custom_Created_Date__c, CreatedDate)

All Answers

Deepak AnandDeepak Anand
Like this = 
BLANKVALUE(Custom_Created_Date__c, CreatedDate)
This was selected as the best answer
Steve BlackwellSteve Blackwell
IF(ISBLANK("custom created date"), CreatedDate, "Custom created date")
(translation: if your custom field is blank, display the value of the default created date, otherwise display your custom created date value)

Plug in the custom created date API name where applicable above (remove the quotes around my placeholder)