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
-
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?
-
What date / time format did you have to use in the end?
Content aside
- 2 yrs agoLast active
- 2Replies
- 85Views
-
2
Following