format database date

Hi arolhaiser ,

Try to go into Power Query Editor.

1.Change the error field data type to text format.

2.Right click the Date2 column, select Using Locale.

3.The data type is changed to date format, and the local selection is the same as the text format.

4.After click OK, the results is as follows.

https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.