V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'

Question

When importing any excel file with a date I get this error. locale is es_ES although en_US is also installed (cannot be unistalled). In the file the date is displayed as 31/01/2025 and formatted as date. The fact thar it shows 2025-01-31 tells me that in first instance Odoo ir correctly interpreting the date but in the process of importing is looking for a different format.
Even tried importing a freshly exported file right from odoo...

Only workwaround i´ve found is to import using CSV, but ne

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
This error happens because Odoo is trying to parse
the date using the format you specified (%d/%m/%Y), but the actual date
in the file is already in the format YYYY-MM-DD (2025-01-31), which
doesn't match.
solution:
1. Adjust the date format in Excel to match odoo import format
Select the date column in Excel. Format -> Number -> Custom date and time
Image [1]

set custom date as (%d/%m/%Y)
Image [2]

OR,

2. Adjust the date format in Odoo to match in Excel
Setting -> Translations->Language

Asis · Answer

I meant in the Odoo import dialog:
imagen [1]

imagen [2]

[1] /web/image/63176715-85111be3/imagen.png?access_token=06c68e7d-aef7-4863-ae21-478d1f4c84f7
[2] /web/image/63176714-90beef92/imagen.png?access_token=86493e67-b146-4023-9350-5722b3c0307d

Ray Carnes (ray) · Answer

>>
The fact that it shows 2025-01-31 tells me that in first instance Odoo is correctly interpreting the date

Are you sure Odoo isn't just showing you what is stored in the field?
What is shown when you click the Formula Bar?
image [1]
(example to show how Excel can display and store two different values)

Try either of these two options:
A column with no format containing and displaying *31/01/2025*
A column with the following format containing and displaying *31/01/2025*
* image [2] *

[1] /w

Gerelateerde posts	Antwoorden	Weergaven
Odoo journal entry modification after posting by import importing	1 apr. 25	3859
Import mehrerer Artikel mit Varianten importing	0 okt. 24	2900
Importing Excel/CSV using custom unique field instead of XML ID importing	2 mei 24	6182
Product export then import duplicates everything importing	0 apr. 24	2935
Import Employees ? importing	2 jul. 23	3882

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!