Date Format Change

[Lyle]

Hi Community

I'm trying to change the date format for the 2nd column but it shows "Error"

The information is coming from the database

Please help me understand why and the way forward

Thank you

[Lyle]

Thank you @Vijay_A_Verma ! Working perfectly

[Vijay_A_Verma · Accepted solution]

First use the below formula to extract date in a custom column and then convert the new column to date

= Date.From(Text.Start([DateField],10))

Replace DateField with your column name