Hello everyone!
A do you think the following problem is caused by trying to import a CSV file?
'2012-12-31 23:59:59' seems not valid for the field 'Date' in row 2 date
Use the format '2012-12-31 23:59:59'
Worse, I edited the file to test and replacement date that is within him, it shows the same error warning and continues the error.
What can it be?
Thank You
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
1
Reply
6638
Views
Hi Diogenes
I believe your problem is that you are trying to import date + time in a date field.
A date field only takes dates (so 2012-12-31 in your example) and does not take time (23:59:59).
You'll either need to change your date field to a datetime field or remove the time from your formatting.
From the official Odoo docs:
date:
A date.
Syntax:
fields.date('Field Name' [, Optional Parameters]),
datetime:
Allows to store a date and the time of day in the same field.
Syntax:
fields.datetime('Field Name' [, Optional Parameters]),
