# Format date and time on gsheets when connecting to the Adalo API

**URL:** <https://forum.adalo.com/t/format-date-and-time-on-gsheets-when-connecting-to-the-adalo-api/20239>\
**Category:** Get Help\
**Created:** [November 30, 2021, 1:39am UTC](https://forum.adalo.com/t/format-date-and-time-on-gsheets-when-connecting-to-the-adalo-api/20239 "2021-11-30T01:39:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![thienhaiao](https://avatars.discourse-cdn.com/v4/letter/t/da6949/32.png) [@thienhaiao](https://forum.adalo.com/u/thienhaiao)\
**Post date:** [November 30, 2021, 1:39am UTC](https://forum.adalo.com/t/format-date-and-time-on-gsheets-when-connecting-to-the-adalo-api/20239/1 "2021-11-30T01:39:16Z")

</div>

Hi guys,  
I use gsheets and use the Adalo API to connect to get the data. All is good, only the date and time format cannot be properly formatted as the attached image.  
Help me please. Thanks very much…

 ![screenshot_1638236274](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/b270c49e92bc801b682f84abc64782df6572c59e.jpeg)

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [November 30, 2021, 6:02am UTC](https://forum.adalo.com/t/format-date-and-time-on-gsheets-when-connecting-to-the-adalo-api/20239/2 "2021-11-30T06:02:19Z")

</div>

Hi @thienhaiao 👋

You need this time format on Adalo or you need to change the Time format in your Google sheet?

Thank you

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [December 10, 2021, 6:02am UTC](https://forum.adalo.com/t/format-date-and-time-on-gsheets-when-connecting-to-the-adalo-api/20239/3 "2021-12-10T06:02:38Z")

</div>

Closed on December 10, 2021, 6:02am UTC

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