# Glide Datetime sync to Gsheets issue

**URL:** <https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991>\
**Category:** Ask for Help\
**Created:** [January 10, 2022, 7:50pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991 "2022-01-10T19:50:35Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Allan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/allan/32/37235_2.png) [@Allan](https://community.glideapps.com/u/Allan)\
**Post date:** [January 10, 2022, 7:50pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/1 "2022-01-10T19:50:35Z")

</div>

I noticed when I use the Glide API to send in a Datetime, it adds the row to gsheets with a singlequote char at the beginning of the cell.

```auto
curl --request POST 'https://api.glideapp.io/api/function/mutateTables' \
    --header 'Content-Type: application/json' \
    --header 'Authorization: Bearer [redacted]' \
    --data-raw '{
    "appID": "[redacted]",
    "mutations": [
        {
            "kind": "add-row-to-table",
            "tableName": "TableName",
            "columnValues": {
                "Datetime": "2022/01/09 12:04:43"
            }
        }
    ]
}'

```

Becomes this in gsheets: `'2022/01/09 12:04:43`

How can I avoid having this singlequote char show up in gsheets?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 10, 2022, 9:01pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/2 "2022-01-10T21:01:45Z")

</div>

Are you filling a date/time column, or a text column?

---

<div class="post-metadata">

**Author:** ![Allan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/allan/32/37235_2.png) [@Allan](https://community.glideapps.com/u/Allan)\
**Post date:** [January 10, 2022, 9:25pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/3 "2022-01-10T21:25:56Z")

</div>

Datetime column.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 10, 2022, 9:47pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/4 "2022-01-10T21:47:27Z")

</div>

I’m not familiar with using the glide api’s, but it appears that you are passing the date/time as a string. If possible, you may need to pass it in a date format. Sorry, can’t really help much beyond that.

@Mark_Turrell and/or @Darren_Murphy may have more experience with that.

---

<div class="post-metadata">

**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\
**Post date:** [January 10, 2022, 10:34pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/5 "2022-01-10T22:34:53Z")

</div>

I use integromat mostly to write back to Glide and I don’t have this problem with time stamps. I format time as YYYY-MM-DD HH:mm always too. Also have you tried with another column first, in case it’s getting confused when it writes in a row… otherwise not sure!

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [January 10, 2022, 11:23pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/6 "2022-01-10T23:23:49Z")

</div>

I agree!

That single quote char means that the cell value must be treated as Text. It’s a MS Excel legacy.

JSON does not have this kind of data type (Date) so, it must be transformed to Text to be sent.

Saludos a todos!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 11, 2022, 1:19am UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/7 "2022-01-11T01:19:22Z")

</div>

In my experience, any time you see timestamps appearing as strings in the Google Sheet, it inevitably means that the associated column in Glide isn’t correctly configured as a Datetime type.

So that’s the first thing I would check. Edit the column in the GDE and ensure that it’s correctly set as a datetime type.

Note that just eyeballing the column header is not good enough. Sometimes you’ll see the calendar icon next to the column name that indicates a datetime type, but when you edit the column, you’ll find that the column has a type of ‘None’. This only ever happens if the column was originally created in the Google Sheet and then synced to Glide. It would never happen if the column was created in the GDE.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 11, 2022, 2:16pm UTC](https://community.glideapps.com/t/glide-datetime-sync-to-gsheets-issue/36991/8 "2022-01-11T14:16:02Z")

</div>

When passing dates to Integromat, I sometimes use parsedate() in Integromat to get the date to function properly with GSheet.