Forum Discussion
Data Format Error: We couldn't parse the input provided as a Date value
Most probably that's literally what the message says - in one of your files there is the value which is expected as Date, but can't be converted into the date.
SergeiBaklan I double and triple checked all data before I did the query and the query refresh. All date columns were already set up as dates on the original worksheets, before I even created the query and when creating the query I made sure to set that column as a date as well, so there was nothing that needed to be 'converted' to a date, as they already were dates.
purpleorchid Did you solve this problem? I have the same issue
I double and triple checked all data before I did the query and the query refresh. All date columns were already set up as dates on the original worksheets, ...... there was nothing that needed to be 'converted' to a date, as they already were dates.
I've often been fooled by dates (in downloaded XLS sheets from one or more of the financial institutions I deal with)...dates that look like dates but are in fact text masquerading as dates. You may have already checked for that condition among your double and triple checking, but I thought I'd mention that for the sake of others as well....
When that's the case, it generally takes text manipulation to change each section of the date (day, moth, year) into its numeric value and then use the DATE function to produce the actual Excel date.
