# AirTable Date/Time field with offset

**URL:** <https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184>\
**Category:** Questions about Thunkable X\
**Tags:** airtable\
**Created:** [November 29, 2022, 11:13am UTC](https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184 "2022-11-29T11:13:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Giuseppe\_Geppo\_Catta](https://avatars.discourse-cdn.com/v4/letter/g/2acd7d/32.png) [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)\
**Post date:** [November 29, 2022, 11:13am UTC](https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184/1 "2022-11-29T11:13:40Z")

</div>

Hi,  
I’m querying a Date/time field from a table in Airtable using WebAPI but the result I get is not the same as in the table.  
In the table I have a “1/9/2020 18:43” value and in the result JSON I get a “2020-09-01T16:43:00.000Z”  
The format is not a problem, is the 2 hours offset i can’t figure out what is due to.  
I can’t find any setting in airtable about it.  
Does anybody knows how to solve?  
Thank you!

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [November 29, 2022, 2:05pm UTC](https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184/2 "2022-11-29T14:05:08Z")

</div>

The time reported by Airtable is UTC or GMT. I would guess you are trying the API from a place that has a time difference of **2 hours** to GMT.

---

<div class="post-metadata">

**Author:** ![Giuseppe\_Geppo\_Catta](https://avatars.discourse-cdn.com/v4/letter/g/2acd7d/32.png) [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)\
**Post date:** [November 29, 2022, 2:45pm UTC](https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184/3 "2022-11-29T14:45:31Z")

</div>

> [@muneer](#):
>
> **2 hours** to GMT.

So the solution is to use a TEXT field or to add a GMT compensation?  
Maybe better the first way having the double time, legal and solar during the year here in Italy ☹  
I hope there was an option to select the time reference…

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [February 27, 2023, 2:46pm UTC](https://community.thunkable.com/t/airtable-date-time-field-with-offset/2155184/4 "2023-02-27T14:46:23Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
