Forum Discussion

godtooro's avatar
godtooro
Helper II
3 years ago
Solved

Date.FromText

Dear all,   I've the next doubt at Powet Query: I've a column as Text with this text: 20221215 (yyyymmdd). Now I want to convert it as Date. I've applied at Power Query this but I obtain "DataFor...
  • TomasAndersson's avatar
    3 years ago

    Your column should be in square brackets, does Date.FromText([Column], [Format= "yyyyMMdd"]) work?