Not able to change Text type column to Date type column in sharepoint list

[h11]

Hi,

I'm not able to change the text type column into date type column in a sharepoint list though I'm the owner of the list and have full access to the list. 

Please find the screenshot below:

I added a calculated column to test its functionality. I removed my owner's access and then reinstated it. I have attempted every solution I found on Google, but none have succeeded. Please help

[v-xianjtan-msft]

Hi @h11 

May I ask if your problem has been resolved? If it has been resolved, please accept lbendlin's reply as a solution. If you still have questions, please allow me to add some details.

The text data in your screenshot looks like a date expressed as a serial number in Excel, with serial number 1 indicating 1900/1/1, which can be converted to date format in Power Query Editor.
Please refer to the following for detailed steps:
1. Select “Transform data” into Power Query Editor, converting your column’s text types to whole number types

2. Insert new step, then enter the following formula in the formula box.

= Table.AddColumn(#"Changed Type1", "NewDate", each Date.AddDays(#date(1899, 12, 30), [Date]))

3. Converting the new column’s text types to date types

Best Regards,

Jarvis Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

This requires a two step process.  Change the column type to a number first. Then change to a date.

[h11]

Hi,

I don't have an option to edit it to any other type for this column in my sharepoint list.

For all the other 20 columns of the list, I'm able to see edit option in column settings and I'm able to change the column type as well. Thank you!

@lbendlin 

[lbendlin]

Do the type changes in Power Query.