+ Start a Discussion
SandrineSandrine 

Wrong caluclation of date

Hello,

I have a formula which gives output age as 33 years old instread of 32
the formula
Age__c = 33
YEAR(TODAY()) -  year(PersonBirthdate)
PersonBirthdate =
PersonBirthdate is standard field
 
Best Answer chosen by Sandrine
VinayVinay (Salesforce Developers) 
Hi Sandrine,

This seem to be expected result, By default, this will set the time to Greenwich Mean Time (GMT),  Can you check user time zone?

https://help.salesforce.com/s/articleView?id=sf.formula_using_date_datetime.htm&type=5

Thanks,