Forum Discussion

ZMadarasi's avatar
ZMadarasi
New Member
1 year ago
Solved

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
Tips and Tricks
  • miTutorials's avatar
    miTutorials
    1 year ago

     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)
)

     

     

miTutorials's avatar
miTutorials
Super User
1 year ago

 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)
)