Date format problem

[Anonymous]

How to change the format from 2020-02-11T08:45:58.6470000 to 2020-02-11 in power bi, it returns wrong date and month if i'm using the format function

[MFelix · Accepted solution]

Hi @Anonymous ,

On the query editor be sure that you have the format of the columns as Date/Time then go to add column and select the Date Only, this will give you a new column with only the date part should work as expected.

then delete the initial column

[Anonymous]

Thank you