跳至内容
菜单
此问题已终结
1 回复
7329 查看

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

形象
丢弃
最佳答案

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]),

形象
丢弃