We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Upload Wizard - How To Upload Dates

Received Response
12
Views
1
Comments
edited May 31, 2018 9:25AM in Integrations and APIs 1 comment

Content

Hi,

I have a date field in a custom object. In my excel file I had a date field. I converted it into epoch using

=(A2-DATE(1970,1,1))*86400

So left with a load of unix-time type data.

When I try and upload this using the data import wizard, I get the error:

Data type mismatch for field hire_date

Can anyone please shed light on this? What format should the data be in, from the original CSV?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!