Date.FromText

[godtooro]

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 "DataFormat Error":

My secuence is: Date.FromText("Column", [Format= "yyyyMMdd"])

Do you know why?

[godtooro]

Please one doubt more and if I want to change two columns?

[godtooro]

Cool @TomasAndersson works perfectly!

@Ahmedx thank you so much for your support!

[Ahmedx]

pls try this

[TomasAndersson · Accepted solution]

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