Forum Discussion
Convert Stuctured Text to DateTime
Hello,
Do you have experience
with Text Columns like "250605_063623" where "YYmmdd_HHMMSS" to
make it Datetime Column "2025.06.05. 6:36:23"?
BR,
Thanks,
Zoltán
Add Custom Column in the Power Query Editor and use the below code..
= DateTime.FromText( Text.Middle([YourColumn], 4, 2) & "/" & Text.Middle([YourColumn], 2, 2) & "/" & "20" & Text.Start([YourColumn], 2) & " " & Text.Middle([YourColumn], 7, 2) & ":" & Text.Middle([YourColumn], 9, 2) & ":" & Text.End([YourColumn], 2) )
3 Replies
Add Custom Column in the Power Query Editor and use the below code..
= DateTime.FromText( Text.Middle([YourColumn], 4, 2) & "/" & Text.Middle([YourColumn], 2, 2) & "/" & "20" & Text.Start([YourColumn], 2) & " " & Text.Middle([YourColumn], 7, 2) & ":" & Text.Middle([YourColumn], 9, 2) & ":" & Text.End([YourColumn], 2) )Thankyou, miTutorials, for your response.
Hi ZMadarasi,We appreciate your inquiry posted on the Microsoft Fabric Community Forum.
Please find attached the screenshot and the PBIX file, which may assist in resolving the issue:
If our response proves helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will benefit other community members who may have similar queries.
Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.
Thank you.
Thanks for the quick solution. It works 🙂
BR
Zoltán
