Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Created Time field and Created Time in formula not matching

Topic Labels: Dates & Timezones
307 0
Showing results for 
Search instead for 
Did you mean: 

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