How do you import date fields from excel?

[#1]

I've been sifting through the Importing articles on the wiki, and trying various settings, but I'm still not having any luck. I want to import a number of tasts and set the Opened date field.

In excel, I've tried using various date formats, the General cell format, and the apostrophe ' prefix in the cell. Whenever I run the import it sets it to a random date like year 0099 AD etc.

[Chuck Tomasi]

Have you checked the source spreadsheet to verified that it is really empty and not a space character or something else that doesn't display? For example, right click on the cell and choose Clear Contents.

[vinothkumar]

Thank you very much chuck. After right clicking and choosing clear contents, it is updating with the blank values.

Thank you once again!!

[Chuck Tomasi]

You are welcome. If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you

[vinothkumar]

Hi Chuck,

I am not having an option to mark this answer as correct might be because I am not the author of the question.

Thanks!

[Chuck Tomasi]

Oh that's right. Thanks for the reminder. It's an 8 year old thread. Normally I recommend people start a new one so it's easier to find in the history. That's fine. A "Helpful" here or there is always appreciated. Either way, I'm glad we got your answer.