Forum Discussion
Power Query inserts wrong dates to Excel
Hello, I am trying to connect an external CSV-file and parse the data into Excel, so that I can use it there. The CSV-file contains one column of timestamps in the format of "yyyy-MM-dd hh:mm:ss...
I must admit, I was surprised to see the US/Liberia date format as the result of importing ISO dates in text format.
PeterBartholomew1 , what exactly do you mean under importing ISO dates in text format ?
I simple meant a text string (CSV file or text field in Excel) in the format "yyyy-mm-dd" rather than being held as numbers, as is usual for Excel calculation. On my machine PQ recognises these as dates and displays them as non-US locale values.
That was such bug some ago. Bot now I can't reproduce it, both 2412.18314.20000 (Beta) and 2410.18129.20158 (Current).