The following error occurred when importing document: DailyFile1.xlsx java.time.format.DateTimeParseException - Text 31/12/2023 could not be parsed at index 0

0
actually i'm trying to import a file and the type i put for my date attribute is date and time and in the file the date is written this way : 24/12/2023 for example. and I get this error :
asked
2 answers
0

Hello,

Your date attribute is of type Date and Time and you are trying to fill it with a string value. So either change the type of the attribute or change the way the data is filled in the excel.

 

Hope this helps!

answered
0

Check the data type column in excel sheet you are importing. It looks like the data type is text instead of date 

 

Hope this helps

answered