Forum Discussion
Solved
Power query Formular or solution
I'm seeking for a power query formula that the date on the highlighted Colum to be united in US locate, it 's pattern is US locate stay on left hand side, right hand side are convert from text. ...
hongpon726 Not quite following. You clearly have a mismatch between your system date settings and the format of the dates your trying to import. From your first screenshot it seems that your system settings use dd/mm/yyyy as the date format, as only dates where the second part exceeds 12 turned into texts. On the other hand, the Shipment Date column is set as a date using the mm/dd/yyyy format.
hongpon726 Sorry, don't really know how to explain it any further. Perhaps I just don't understand your questions.