Hi Ammar,

I presume that you are using dd/mm/yyyy?

After splitting the text into 3 columns, recombine it with / as the separator.  You can then convert it using locale to a date.

See attached file for the query/steps.

Regards

Phil

Hi Philip

Thank You for the clarification

but actually, I'm looking to solve the error if I co with -power query ---> add column ---->custom column 

same in the excel and photo 

I would like to know why I got Error?

Hi Ammar,

The order of the parameters for #date are year, month, day.

You've got day, month, year.

https://docs.microsoft.com/en-us/powerquery-m/sharpdate

This is the correct format

= Table.AddColumn(#"Changed Type1", "Custom", each #date([Test.3],[Test.2],[Test.1]))

Regards

Phil

Many Thanks

You're welcome.