Forum Discussion
Change text data type to date data type
Hi, I have fiscal Period column and I want to convert in to “Date” format.When tried to change data type to “date” format It has created very weired number. I do not have any DATE column in my dat...
In Power Query, change the column type to Text.
Add a column like this
Text.Combine({[Fiscal Period], "01"})That just adds 01 to the end of the data.
Change the new column type to Date
Hi Anonymous
What is the error you are getting?
You can try this after converting it to date:
select the format of your date from this dropdown:
let me know if this works.
Thanks,
Tejaswi
Hi,
When i have chaged Data Type to Date,I am getting below weird numbers,
- HotChilli
Community Champion
In Power Query, change the column type to Text.
Add a column like this
Text.Combine({[Fiscal Period], "01"})That just adds 01 to the end of the data.
Change the new column type to Date
Thank you so much ...
Hi,
One more information i want to convert it to YYYYMM.Thanks