Created Date formula calculating incorrectly

Hollie Green

My formula is =DATEONLY(Created@row) however it is giving a day later than the created date on two of the rows but the other 2 rows are calculating correctly.

David Tutwiler

I think the problem is that function converts the time into GMT and it is likely different than your timezone. I will copy the link below, but here is a screenshot where Smartsheet identifies the potential problem.

https://help.smartsheet.com/function/dateonly?frame=0&nav=1