Another day. Another stupid roadblock. A EditorX content manager collection is not supporting any common date/time formats known from real life.
ISO 12h 2021-11-23 2:12pm > NOPE
ISO 24h 2021-10-22 16:38 > NOPE
US 10/20/2021 2:42pm > NOPE
EU 20/10/2021 13:42 > NOPE
Even date/time formats EditorX is telling you to use are not working.
Then I mixed the US date format with EU time format. And it looked good. But 70% of the records got imported without a date. The same with EU date format and EU time format.
The result are empty fields.
I double checked my CSV export from Airtable several times. It's not the CSV.
This has cost me 4 hours today with no solution. Again.