Skip to Content
This question has been flagged
importing
2 Respostes
1012 Vistes
Avatar
Asis

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 need excel functionality to work.

Avatar
Descartar
Avatar
Asis
Autor Best Answer

I meant in the Odoo import dialog:


Avatar
Descartar
Avatar
Ray Carnes (ray)
Best 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?

(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

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Odoo journal entry modification after posting by import
importing
Avatar
Avatar
1
d’abr. 25
843
Import mehrerer Artikel mit Varianten
importing
Avatar
0
d’oct. 24
824
Importing Excel/CSV using custom unique field instead of XML ID
importing
Avatar
Avatar
Avatar
2
de maig 24
3249
Product export then import duplicates everything
importing
Avatar
0
d’abr. 24
983
Import Employees ?
importing
Avatar
Avatar
Avatar
2
de jul. 23
1739