Failed to Convert String to Date
This is the format that eone SC produces when you use the Get data function in the Excel addin:
2014-01-31T00:00:00-05:00, the question is, what type of format is this? I do not see it as an option and cant create a custom.
That date format is a UTC format which is typically used in XML files as it's a universal format that is not different by country.
You are saying that on your original used of the Excel Add-In it doesn't send the date correctly? Is your destination Dynamics GP? If so, change the destination to Dynamics GP – File and it will create an xml representation of the data that would be sent to GP.
You can send me that file at email@example.com
Any update on this? I had sent the requested files sometime in the past 2 weeks and have not heard anything since?
In testing this I have found an issue with the Add-In. It's not pulling date columns correctly.
The work around is to put the single quote in front of the dates. Change the column to a Text data type. Remove the single quote from the date values and enter actual dates. The add-in will treat them as strings and the map will integrate correctly.
Thanks, I had already implemented the quote fix. Any idea if this glitch will be fixed?
It will be fixed but I'm not sure of a time frame yet.
If you would like to submit an answer or comment, please sign in to the eOne portal.