Forum Discussion

Anonymous_'s avatar
Anonymous_
Frequent Visitor
11 months 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. I have tried through the date formats given already in power query. I have tried the Date.FromText formula as well and to no avail. 

 

Is there anything that I'm missing? Please help! 

 

Thanks in advance! 

 

 

Need Help
  • dufoq3's avatar
    dufoq3
    11 months 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

5 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    11 months 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
    Super User
    11 months 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

     

     

     

  • v-echaithra's avatar
    v-echaithra
    Community Support
    11 months 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.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    11 months ago

    Hi Anonymous_ ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    11 months 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.