Stagging Table data load issue

[Kavyasri]

Hello Community,

I am trying to load data from excel to servicenow instance. So, Attached a file to the data source. In the excel file,  contract start date and contract renewal date is available for all the contract number. But, when I check it in the stagging table, Contract start date and contract renewal date is available only for some contract numbers.

[Anand Kumar P]

Hi @Kavyasri ,

In the transform map field definition, you should be able to update the date format to yours yyyy/MM/dd hh:mm:ss.

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Narsing1]

Open the definition of Staging table and modify these 2 date fields to string type fields and try again.

Thanks,

Narsing