+ Start a Discussion
Prince VenkatPrince Venkat 

Number Type Formula field

Number Type Formula Field

Criteria : (Create Date – Date of Birth)/365.2

Date of Birth is a field in the org

How to consider Create Date Here?

Thanks in advance

 

 

Best Answer chosen by Prince Venkat
Sai PraveenSai Praveen (Salesforce Developers) 

Hi Venkat,

Can you try this formula.

FLOOR(( DATEVALUE( CreatedDate ) -Date_of_birth__c +1)/365.2425)

If this solution helps, Please mark it as best answer.

Thanks,

All Answers

Sai PraveenSai Praveen (Salesforce Developers) 
Hi Venkat,

Can you help the community to understand exact requirement for this. Do you need no of days between two dates. One is CreatedDate(Standard) field and the other is Date of Birth(Custom fielf of type Date) ?

Thanks,
 
Sai PraveenSai Praveen (Salesforce Developers) 

Hi Venkat,

Can you try this formula.

FLOOR(( DATEVALUE( CreatedDate ) -Date_of_birth__c +1)/365.2425)

If this solution helps, Please mark it as best answer.

Thanks,
This was selected as the best answer