0

Importing Date/Time from CSV

I have formats in a CSV file like the ones below but Ninox doesn't import them correctly. I've tried changing the format to ISO 8601 (the standard), but Ninox still isn't importing hundreds of values.

The raw (in CSV file) date formats are like this:

9/3/2021 4:15 PM

or

10/30/2020

What should these formats look like so Ninox will successfully import both values examples above into a DateTime field?

Thanks,

2 replies

null
    • ninox.1
    • 2 yrs ago
    • Reported - view

    Solved....I wrote a separate program to do this conversion.

    Then, ..., it imported fine.

    Any reason why Ninox doesn't (and use by default, at least) the ISO 8601 date standard?

    • Brendon.1
    • 2 yrs ago
    • Reported - view

    What date / time format did you have to use in the end?

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 85Views
  • 2 Following