Skip to main content

I am trying to import data into Salesforce from Excel

Having issues with the date fields.

 

Please refer below.

 

Excel (From)

Start time and End Time in the source excel file is as shown below.

Start time 1/30/22 7:55 

End Time 1/30/22 10:52

 

Salesforce (To)

Start time 1/30/2022, 1:55 AM  

End Time  1/30/2022, 4:52 AM

 

I checked the timezone settings. It is set to Central Daylight savings America/Chicago.

But the date comes over as below.

 

Please let me know what I am missing...

 

Thank you!

답변 1개