CODEWITHSUNDEEP
c#sharepoint
Vivek Bernard
Vivek Bernard

Reputation: 2073

How to change the data type of a Sharepoint Column from number to datetime?

I have a Sharepoint 2010 list which has a column of type "Number" how do I change the data type to DateTime.

Upvotes: 0

Views: 10030

Answers (2)

naivists
naivists

Reputation: 33511

Number and Datetime fields are quite different and directly switching from number to date via web interface is not allowed. However, you can first change number->text and then text->date. (Of course, you may lose your data during conversation)

Upvotes: 3

Sravan Kumar
Sravan Kumar

Reputation: 1457

In the ribbon..follow the path as shown below

ListTools-->List---->List Settings-->Columns--->Click on "Your column name"-->Selct date time in "The type of information in this column is" radio button-->Additionally (Date time format under description if needed)--->Click Ok

Upvotes: 0

Related Questions