How to pass correct datetime

ERPNext
1

“exception”: “pymysql.err.OperationalError: (1292, "Incorrect datetime value: ‘21-08-2024 17:16:00’ for column _6ecb14d2b46d316a.tabCG TaskDefinition.due_date at row 1")”,

2

Please check this comment: Bench Update error - pymysql.err.InternalError: (1292, u"Incorrect datetime value: '24.10.2018'") - #5 by nabinhait

1 Like
3

u can pass like this

Example :

2024-05-02 11:33:02.734604

4

yes i have passed

“pymysql.err.OperationalError: (1292, "Incorrect datetime value: ‘21-08-2024 17:41:00.000000’ for column _6ecb14d2b46d316a.tabCG TaskDefinition.due_date at row 1")”

5

please share the screen shot of field name or field type which field have u throw this error

6

Screenshot from 2024-08-21 17-53-36

7

change the date like this and try it

2024-08-21 17:41:00.000000

1 Like
8

Its working

Thanks @Meet & @NCP