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

**URL:** <https://community.noloco.io/t/importing-csv-datetime-converting-to-us-format-not-importing-at-all/744>\
**Category:** Bugs\
**Created:** [May 26, 2024, 10:13pm UTC](https://community.noloco.io/t/importing-csv-datetime-converting-to-us-format-not-importing-at-all/744 "2024-05-26T22:13:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [May 26, 2024, 10:13pm UTC](https://community.noloco.io/t/importing-csv-datetime-converting-to-us-format-not-importing-at-all/744/1 "2024-05-26T22:13:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [May 27, 2024, 7:42am UTC](https://community.noloco.io/t/importing-csv-datetime-converting-to-us-format-not-importing-at-all/744/2 "2024-05-27T07:42:03Z")

</div>

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

```auto
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.

---

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [May 28, 2024, 11:12am UTC](https://community.noloco.io/t/importing-csv-datetime-converting-to-us-format-not-importing-at-all/744/3 "2024-05-28T11:12:43Z")

</div>

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”)