How to enter datetime in Excel Data Source

I am using an excel data source to import data to generate complex structures, I have managed to work with creating relationships between the different sheets, but the one thing that I can't figure out how to do is how to enter dates so that I don't get an invalid datetime error.

Comments

Can you please be specific about what error you are seeing? What is the message, exactly? Do you see it when configuring the data source or when running your test suite? Do you see the error in the Console view or the Quality Tasks view? If in the Quality Tasks view, is there detail if you double click the error? Is the error reported from a particular test? If so, how is that test configured to use the data source?

Not sure what you mean about how the test is configured to use the data source

Based on the error message you provided, you must be configuring a dateTime field in the Form Input view against the "Taxes:Start" column. "1/1/17" is not in the correct format for dateTime as defined by XML Schema specifications. It must include both a date and a time component and be formatted correctly. From https://www.w3.org/TR/xmlschema-2/#dateTime :