Importing csv datetime converting to US format/not importing at all

Hello,

I have records that i am trying to import into a collection. This includes a datetime field in UK format. When i import into a collection though:

  1. not all datetime records are being imported
  2. the few that do, import into the collection have been converted to US date/time.

Hey @cizict the dates should be in ISO timestamp formats where possible which is YYYY-MM-DD or YYYY-MM-DDTHH:mm:ss

Eg today, May 27th at 09:40 am

2024-05-27
2024-05-27T09:40:00.000

This is a pretty common format when exported, and I suspect that’s the problem.

We do try our best to interpret other dates, but with ambiguous dates, such as 12/05/2024 it’s hard to know if that’s May 12th or December 5th.

Hi Darragh,

Thanks for that. I’ve used a formula to convert the date to fix that.

To recap for those reading, i was manually importing a CSV file, via Excel, into a Noloco table. The dates we in dd/mm/yyyy hh:mm:ss format in the csv file. To fix this, i used the formula below to convert the date/time into the ISO timestamp format Darragh outlined:

=TEXT(A2,“yyyy-mm-ddThh:MM:ss”)