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_ ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.