Hey there,
I imported around 50k rows from an Airtable base. This also included Date fields. I’m now playing around with python scripts to do my data processing.
I now noticed that imported date data seems to be in a different format then what Seatable usually creates. For a simple date column without minute precision; I’m getting this back:
“'2024-01-22T00:00:00Z”
This also seems to be causing issues when querying via SQL Queries.
SQL Query: SELECT * FROM Bestellungen WHERE `Datum Abb` = '2024-01-22' AND Bestellart = 'Onlinebestellung'
[Warning] format date: Invalid isoformat string: '2024-01-16T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-19T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-17T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-22T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-23T00:00:00Z'
[Warning] format date: Invalid isoformat string: '2024-01-21T00:00:00Z'
It looks like the query is still working (still getting the results I’m expecting) but i’d rather work on fixing the data instead.
Any idea? I tried changing the date format on the column but looks like the “wrong” data still stays there.
