Data Uploader Not Displaying Time from Import

12/30/20
Answered - Pending Review

Hello,

I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and changed the format of the cell to display as a time.

When

the data is imported it messes up the time, see screen shot attached. Any advice on how to resolve or at least a workaround to pull in the timestamp.

Popular Tags:

Answers

Sign In or Register to comment.