Forum Discussion
Power query Formular or solution
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.
Yes, because I'm snuggling choose on the locate, I have them all in locate, but however not it is not quite right, for example 1, i want the month keep in December, now it is in Aust.
Second Example become Aug. and the other become December
hongpon726 Sorry, don't really know how to explain it any further. Perhaps I just don't understand your questions.
- Data are mis match, i want to clear up and I use Power query to do that. the first picture was my question, the rest of comment and photo was trying to explaining after the locate setting mm/dd/yy is still mm/dd/yy
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.