Change Type locale not working in query editor for Date

ashish18 

Hi, one of the workarounds would be creating a function using below M, 

(DateText as text) as datetime =>
let
    Day = Text.Start(DateText, 2),
    Month = Text.Middle(DateText, 3, 3),
    Year = Text.Middle(DateText, 7, 2),
    Time = Text.End(DateText, 8),
    FullDate = Day & " " & Month & " 20" & Year & " " & Time,
    ConvertedDate = DateTime.FromText(FullDate)
in
    ConvertedDate

then invoke it in Table.TransformColumns()

let
    Source = Source,
    ConvertedTable = Table.TransformColumns(
        Source,
        {{"Column1", each Convert(_), type datetime}}
    )
in
    ConvertedTable

Hi ashish18, 

What date format are you wanting it to display as? 
You can select different date formats in the format dropdown, or use a custom format using a pattern. 

If you found this helpful, consider giving some kudos. If I answered your question or solved your problem, mark this post as the solution to help future users find it quickly. 

Hi ashish18,

Have you had a chance to review the solution we shared by MasonMA ? If the issue persists, feel free to reply so we can help further.

Thank you.

Hi ashish18,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

Hi ashish18,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.