Forum Discussion

maricci1's avatar
maricci1
New Member
9 months ago
Solved

Data formatting issue

Hello, I have a problem, when I import data from the MySql database, the date is of type text in the form of mm/dd/yyyy, I can't change the database....and when I transfer that column to date, short ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    9 months ago

    maricci1 

    maybe you can Using Locale and select the proper locale to get the correct date type.

     

sayan_07's avatar
sayan_07
Frequent Visitor
9 months ago

the easy way is just Paste this M Code :  = Date.FromText([Date column Name], "en-US")


2nd Method :

Right Click the Date column in Power Query and Click data type Correct the Date Type

 


Then Go to Using Locale and change the Locale to English (United States)