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
Mirelis SotoMirelis Soto 

How to calculate a person age from 2 date fields?

Hello all, 
I have 2 fields Birthdate__c (encrypted) and First day of school__c., both are Date fields.

A new formula field Age_first_day_of_school__c will calculate how old is a person on the first day of school utilizing the Birthdate field and the First Day of School field. 

My questions are; Is this possible and if so how the formula would look? Encrypted Date fields can be utilize on formulas?

Thank you! 

VinayVinay (Salesforce Developers) 
Hi Mirelis,

I dont think formula will work in above scenerio.  Below are supported operators and functions: 
& and + (concatenate)
BLANKVALUE
CASE
HYPERLINK
IF
IMAGE
ISBLANK
ISNULL
NULLVALUE
https://help.salesforce.com/s/articleView?id=sf.security_pe_formulas.htm&type=5

Please mark as Best Answer if above information was helpful.

Thanks,