Forum Discussion

villa1980's avatar
villa1980
Resolver II
2 years ago
Solved

New Append Query Date Help

Me again,    I have 2 tables both with dates (formatted as Date).  When I append the 2 tables to a New Table in Power Query Editor the New table contains the Date column but is text. When I conver...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi villa1980 

     

    Please supply some sample data from both files so we can test this.

     

    Not sure that only some of the dates are being converted to US format.  A column can't have mixed formats so I'd say all the dates are being converted to US format.

     

    If you need to convert the dates to a specific regional format you should convert the column using Locale

     

    Change Type Using Locale with Power Query

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi villa1980 

 

Please supply some sample data from both files so we can test this.

 

Not sure that only some of the dates are being converted to US format.  A column can't have mixed formats so I'd say all the dates are being converted to US format.

 

If you need to convert the dates to a specific regional format you should convert the column using Locale

 

Change Type Using Locale with Power Query

 

Phil