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 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.