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
dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
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