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

Powiązane posty	Odpowiedzi	Widoki
Odoo journal entry modification after posting by import importing	1 kwi 25	1594
Import mehrerer Artikel mit Varianten importing	0 paź 24	1279
Importing Excel/CSV using custom unique field instead of XML ID importing	2 maj 24	4134
Product export then import duplicates everything importing	0 kwi 24	1412
Import Employees ? importing	2 lip 23	2215

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!