# Linked google sheet - datetime not always imported **URL:** \ **Category:** Bugs\ **Created:** [January 15, 2026, 2:56pm UTC](https://community.noloco.io/t/linked-google-sheet-datetime-not-always-imported/2340 "2026-01-15T14:56:39Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\ **Post date:** [January 15, 2026, 2:56pm UTC](https://community.noloco.io/t/linked-google-sheet-datetime-not-always-imported/2340/1 "2026-01-15T14:56:39Z")
I have linked a Google Sheet as a Data source. All data appears to have been linked correctly, however, I have a Date Time column that has not always populated in the linked table in Noloco. The column is formatted as a Date Time in Google Sheets (i’m in Ireland so the format is dd/mm/yyyy), and the corresponding column in Noloco is a Date column formatted as Date Time. I noticed that the datetime field in Noloco is in the wrong format. e.g. dates 09/01/2026 in Sheets are imported but as 01/09/2026. Today’s date in the sheet 15/01/2026 are not imported. Note, after noticing this anomoly, i switched on the the ‘Use Consistent time zone GMT’ toggle but that has not worked. See screenshots below of linked Sheet and Noloco table: ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/5/5ef196c9c421f067cb59df53e82e0f62872d9439.jpeg) ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/8/885c5c8873cd865ed0fc345532c257850840cb05.jpeg) ---
**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\ **Post date:** [January 15, 2026, 4:06pm UTC](https://community.noloco.io/t/linked-google-sheet-datetime-not-always-imported/2340/2 "2026-01-15T16:06:28Z")
Update - this appears to be working ok now! Perhaps the ‘Use Consistent time zone GMT’ toggle worked but there was a delay?