Hi,
I have been struggling for days on how to convert "start time" column to Date format, so that I can directly use it as Date in Pivot Table.
when loading this CSV file to Power Query, I tried change data type, split column to month / Day / Year, and format them to whole number respectively, then merge again..... but whatever I tried, I always ended up with a portion of that column failed with error "Can not convert input data to Date format."
i have no idea what is wrong out there.
appreciate if any advice.
Hi Yan,
The problem is that the CSV file dates are in mm/dd/yy format and your PC is probably in dd/mm/yy format, or vice versa. You need to change the data type using locale - see session 4.03 of the Power Query course for how to do this.
Mynda
Hi Mynda,
it worked perfectly, much appreciated, I should have reached out earlier. cheers.
