I'm having trouble with unexpected Date Time conversion error. This error happened in the Input Data tool. I'm importing some data from an Excel spreadsheet. The warning reads: "Input Data (4) Conversion error on record: 2398 - Invalid date - Latest date supported is Dec 31, 9999".
The thing is that when I scrolled down to record 2398, I found no error at all in that record, but a few lines above it have some serious errors: The columns that are supposed to be strings like First Name and Last Name were all converted to 00:00:00. I didn't find the same error in other rows.
I DON'T want those columns to be converted to Date Time at the input stage. I can't see why this happened to those specific columns. I didn't see anything odd in the data source file. So I'm looking for help from the community.
UPDATE 28/12/2021
To give you a little bit more context: the workflow starts with an input file which is also the output file. Data from other files will be read in and appended to this input file. The batch macro workflow goes on and on until data from all the files are imported and appended to the input file. Currently, I'm configuring the Output Data tool to overwrite sheet or range.
The warnings didn't happen when I first read in the original data but happened in the second attempt when I re-run the workflow to read in the updated input file. All the warnings disappear in rounds thereafter. Since I'm dealing with customer data; unfortunately, I'm not able to provide examples. Hope that this clarifies my problem!
