function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
BillyB11085BillyB11085 

Formula to make an expiration date field

I am trying to make an expiration date field that will add 365 days to the date created field!  Can anyone help me out?

 

Thanks,

 

BB

Best Answer chosen by Admin (Salesforce Developers) 
flewellsflewells

The created date is a date/time field, so you need to convert it to a date field using DATEVALUE.  This should work:

 

DATEVALUE( CreatedDate ) + 365

All Answers

flewellsflewells

The created date is a date/time field, so you need to convert it to a date field using DATEVALUE.  This should work:

 

DATEVALUE( CreatedDate ) + 365

This was selected as the best answer
BillyB11085BillyB11085

That was perfect, thank you very much!