Forum Discussion

Anonymous_'s avatar
Anonymous_
Frequent Visitor
1 year ago
Solved

Excel - Power Query

Hi Everyone!    My date column has values in the format of mm/dd/yyyy and are recognised as text. The issue is that I am unable to convert them to the date type. Each time I try, it throws an error...
Need Help
  • dufoq3's avatar
    dufoq3
    1 year ago

    Hi Anonymous_, check this:

    Before

     

    After

    let
    Source = #table(null, {{"05/25/2025"}}),
    ConvertedToDate = Table.TransformColumns(Source, {{"Column1", each Date.FromText(_, [Culture="en-US"]), type date}})
in
    ConvertedToDate
v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous_ ,

Thank you ronrsnfld , dufoq3  for your response.

I hope the information provided is helpful. I wanted to check whether you were able to resolve the issue with the provided solutions. Please let us know if you need any further assistance.

Thank you.