Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Format issue

 

Date Column

 Above is how the column looks like on my table, when i'm using the Format([Column], "YYYY MMM"), This function returns wrong year and month, does anyone knows how to fix this? 

  • Hi,

    go to power query editor and transform the column into a proper datetime column like 2020-01-16 13:53:43.

     

    Regards FrankAT

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion

    Hi,

    go to power query editor and transform the column into a proper datetime column like 2020-01-16 13:53:43.

     

    Regards FrankAT