Forum Discussion
Error with dates when appending tables
I've appended 6 excel tables and one access query as a new table in power query. When working with the data I noticed some very odd dates, so looked back at the appended result, and noticed some date...
Anonymous ,
To see the code that Query Editor is creating with each step, check The Advanced Editor.
Hi Anonymous,
I am sure, this is an issue with your date column data type, make sure to convert the column data types to date or datetime before appending. Please let me know, If issues still persist.
Thanks,
Amit
Ok I will go through all the individual tables and see if that helps.
v-chuncz-msftCommunity Support
Anonymous ,
To see the code that Query Editor is creating with each step, check The Advanced Editor.