Forum Discussion

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago
Solved

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

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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

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's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Do the type changes in Power Query.