Help

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

Linked date record not adjusting based on time zone

Topic Labels: Dates & Timezones
389 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am working on an interview scheduler airtable base. I have an availability table which is linked to a scheduled times table. Dates in the availability table show in local time, but once a time slot is entered or selected into the scheduled times table it does not show up in local time. How can I make it do so? Screenshots are attached.

Screen Shot 2021-08-02 at 4.30.49 PM

Screen Shot 2021-08-02 at 4.31.18 PM

1 Reply 1

Welcome to the community, @Amina_El-Ashry! :grinning_face_with_big_eyes: I’m not able to replicate this behavior on my end. The date in the link is the same as the date in the primary field of the source table.

That aside, one way around this problem is to move the actual date to a secondary field, then turn the primary field into a formula that formats the date using DATETIME_FORMAT(). That will create an exact match in the text of any links to these appointment records because the formatted date becomes text.