Created Time field and Created Time in formula not matching

Topic Labels: Dates & Timezones
519 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello - I am trying to use the CREATED_TIME field in a formula and am getting a different date:
Created time field show Date format as Local 2021-01-30 9:59pm
When I use this in a formula: FirstName &" “& LastName &” "&DATETIME_FORMAT(CREATED_TIME(), ‘YYYY-MM-DD’) it shows FirstName LastName 2021-01-31
I’d appreciate any insight on why these dates are showing as 2 different days.
Thank you

0 Replies 0