Forum Discussion
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 "DataFormat Error":
My secuence is: Date.FromText("Column", [Format= "yyyyMMdd"])
Do you know why?
Your column should be in square brackets, does Date.FromText([Column], [Format= "yyyyMMdd"]) work?
4 Replies
Your column should be in square brackets, does Date.FromText([Column], [Format= "yyyyMMdd"]) work?
pls try this
Cool TomasAndersson works perfectly!
Ahmedx thank you so much for your support!
Please one doubt more and if I want to change two columns?
