Excel - Power Query

[Anonymous_]

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! 

[v-echaithra]

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.

[v-echaithra]

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]

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.

[ronrsnfld]

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

[dufoq3 · Accepted solution]

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