Forum Discussion

anglefbi11's avatar
anglefbi11
Helper I
2 years ago
Solved

mutliple time format issue

hi dears i am using power query and i am facing a complicated issue with time format. i have a data with mixed 12 hours, 24 format . i need to know how to get them all as the same format . i treid u...
Need Help
  • anglefbi11's avatar
    anglefbi11
    2 years ago

    hi guys

     

    thanks god i found the soulution finally . i changed my regional format in my pc from english UK to English US and it has been solved

anglefbi11's avatar
anglefbi11
Helper I
2 years ago

dears

kindly look what happened when i change the column to date and time

 

 

dufoq3's avatar
dufoq3
Community Champion
2 years ago

This will solve your issue. Add as custom column:

 

try DateTime.FromText([Date], "en-US") otherwise DateTime.FromText([Date], [Format="M/d/yy hh:mm tt", Culture="en-US"])

 

If you want to transform existing [Date] column, add this as new step (just replace Previous_Step😞

= Table.TransformColumns(Previous_Step, {{"Date", each try DateTime.FromText(_, "en-US") otherwise DateTime.FromText(_, [Format="M/d/yy hh:mm tt", Culture="en-US"]), type datetime}})