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
ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
1 year ago

Probably you are missing the culture argument.

Try 

TransformDate = Table.TransformColumnTypes(Source,{{"date", type date}}, "en-US")

 

or right-click the column and select 

 

Change Type => Using Locale => and select Date and English-United States