convert text in to date-Two format of dates

[RAKESH1986]

Hi All,

i am getting below issue, pls help me to resolve this it

I have a date field ..but these have two types of values in excel.. one is proper date format (2/1/2023) and another is text format but a date value  (13-01-2023), neither am I unable to convert this in excel nor in power bi..both are giving problem..

pls help me with how to solve this problem.

when I am converting this in date format, getting the below error.

[ronrsnfld · Accepted solution]

Try:  Change Type with Locale => Date => English(United Kingdom)

which will generate this code:

#"Changed Type with Locale" = Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}}, "en-GB")
in

Change #"Previous Step" to the name of that step if you are using this instead of the UI.

If that doesn't work, please share

• the original source (the type of source -- eg CSV File) of the data,
• a copy/paste of some data from that source (as text, not a screenshot),
• the M-Code in the advanced editor and
• your Windows Regional short date settings.