Getting Error while Creating Bulk warranty in Assets management

[Vikas.Dhiman]

Getting Error while Creating Bulk warranty in Assets management.
CSV file attached for sample. Please find the below error while uploading by connector. Few details uploaded by the same csv file but some are getting error.

Attachment(s)

warrantyERROR.docx   174 KB 1 version

wtest1.csv   270 B 1 version

[Igor Perevozchikov]

Hi Vikas.Dhiman!

Please update your csv file to provide there date/time in this format 2020-02-13 07:39:00.000 for "Start Date" and "End Date" columns, then rule will successfully import data.

Best regards,
IP.

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------

[Vikas.Dhiman]

Hi Igor,

Thanks for your reply on my post, I has perform the suggested steps for the same but still we are getting the same error. Please refer the attached snapshot for your information.

[Igor Perevozchikov]

Hi Vikas.Dhiman!

It doesn't accept date/time in this format dd/month/year

It accepts only if you will provide date/time in this format year-month-day
Using this format below, it will successfully import date/time information in database

Contract Type,Name,Start Date,End Date,Status,Approved,Assigned User,Description,Serial Number
Warranty,0344-PANAJI-026,2022/08/14 00:00:00.000,2029/12/22 00:00:00.000,Active,Yes,,Desktop,UXBDCSI250L2598931
Warranty,0377-VASHEE-156,2022-08-14 00:00:00.000,2028-08-14 00:00:00.000,Active,Yes,,Desktop,UXBDCSI250L2598935

Best regards,
IP.

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------