콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
7408 화면

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

아바타
취소