Solved: Date Format function issue

Anonymous · ‎02-11-2020

Date Format Issue Can Anyone help with date format, when i'm using the format function, it returns the wrong month and year

v-lid-msft · ‎02-12-2020

Hi @Anonymous ,

We can try to change the data type of this column from text to datetime in the Power Query Editor to meet your requirement:

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-lid-msft · ‎02-12-2020

Hi @Anonymous ,

We can try to change the data type of this column from text to datetime in the Power Query Editor to meet your requirement:

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.