DATE import error IN CSV file

Question

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

Yenthe Van Ginneken (Mainframe Monkey) · Answer

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.

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!