Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
1949 Widoki

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.

Awatar
Odrzuć
Najlepsza odpowiedź

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


set custom date as (%d/%m/%Y)


OR,


2. Adjust the date format in Odoo to match in Excel

Setting -> Translations->Language

Select your language and change the date format.




Hope it helps


Awatar
Odrzuć
Autor Najlepsza odpowiedź

I meant in the Odoo import dialog:


Awatar
Odrzuć
Najlepsza odpowiedź

>>  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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
kwi 25
1450
0
paź 24
1212
2
maj 24
4016
0
kwi 24
1336
2
lip 23
2121