CSV reimport fails on date field with Ignore timezones enabled

[ConorWebb96]

Checklist

• I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Cloud
  • Tenant ID: cprem

Describe the bug
When exporting the employees table from the sample data and then re-importing the same exported file, an error is thrown during CSV import. The issue appears related to the date field: the import fails if Ignore timezones is toggled on but succeeds if it’s toggled off. The only difference observed in the data is the presence of a Z at the end of the DateTime string (indicating UTC).

To Reproduce
Steps to reproduce the behavior:

1. Create a new app
2. Export the employees table from the data area
3. Try to reimport the exported CSV
4. See error

Expected behavior
You should be able to reimport the exported CSV file without errors if the file has not been modified since export.

Screenshots

[linear]

BUDI-9478 CSV reimport fails on date field with Ignore timezones enabled