[csv import] - Detect in the errors prior to starting the import the dates that are not well formatted

[StephanieJoly4]

Bug Description

Upload a csv file that contains a column with values such as 2023, 2022, 2025, etc.
Map this column into a field with DATE type
(though this is not a date, trying to map such a value to a date type field happened to several users)

Issue:
this error (mapping a year into a date field) is not detected as an issue by the UI (in the yellow cells)
Then, "an error occurred" msg is displayed, showing the user the import was not successful.

Ask:
Detect this as an issue with yellow cells prior to starting the import, telling users how to fix the issue: input a date and not a year (and if enough room, tell them they can configure the display format to have only the year displayed in the UI via the data model)

cc @etiennejouan per our discussion but feel free to reassign, thank you!

[StephanieJoly4]

[etiennejouan]

Thanks for all the details. Getting this issue in my sprint !