Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert TEXT date into DATE - POWER QUERY

Hello, 

I have a date in the format of text, please see below. How can I turn this into format date dd.mm.yyyy ? 

IF I use change the format in the header, this step doesnt work and make an "error" in the all the fields. 

 

Many thanks in advance. 

 

Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, Anonymous 

    Table.TransformColumns(your_table, {"Zdroj...", (x) => Date.FromText(x, [Format = "ddMMyyyy"])})

1 Reply

  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper User
    3 years ago

    Hello, Anonymous 

    Table.TransformColumns(your_table, {"Zdroj...", (x) => Date.FromText(x, [Format = "ddMMyyyy"])})