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:
