Data import will not accept properly formatted dates

[heyjoeway]

Checklist

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

Hosting

• Cloud
  • Tenant ID: nui34t9grn89vy

Describe the bug
When importing data to a new table and setting a field format to "Date", I receive an error that the formatting isn't correct even though it is:

Invalid format for field "Test": "2024-10-31T00:00:00Z". Datetime fields must be in ISO format, e.g. "YYYY-MM-DDTHH:MM:SSZ".

To Reproduce
Import a CSV to a new table with the following content:

Test,Test2
2024-10-31T00:00:00Z,1234

OR a JSON with the following content:

[
	{
		"Test": "2024-10-31T00:00:00Z",
		"Test2": "1234"
	}
]

Make sure that the "Test" field type is set to "Date".

Expected behavior
The data should import without error.

Screenshots

App Export
This is on a brand new app.

Desktop (please complete the following information):

• OS: Windows 11 24H2 (26100.3476)
• Browser: Chrome
• Version: 134.0.6998.89

Additional context
N/A

[linear]

BUDI-9151 Data import will not accept properly formatted dates

[heyjoeway]

It seems like the message is misleading. Exporting an existing date from Budibase and reimporting does work, but the format is slightly different from what is indicated:

• For dates, you can use ISO 2014 and simply leave out the time portion, eg. 2024-10-31
• For times, you need to explicitly specify the decimal portion, eg. 2024-10.31T00:00:00.000Z