How to change column "Date" from "Text" to "Date-Time" in Document Library.

Question

_{Thursday, October 9, 2014 10:23 AM}

How to change column name "Date" from "Single line of Text" to "Date and Time" in Document Library.

All replies (4)

_{Friday, October 10, 2014 9:20 AM ✅Answered}

Hi,

If you would change column type, you might need to re-create column.

If you would like a text column to display in date format, you could refer to the links below:

http://sharepoint.stackexchange.com/questions/45774/how-to-convert-date-field-in-single-line-of-text-using-calculated-columns

http://yasuanantha.blogspot.com/2008/06/to-convert-text-column-to-date-column.html

Regards,

Rebecca Tu
TechNet Community Support

_{Thursday, October 9, 2014 10:36 AM}

Hi ,

       You have to delete and create the column again.

Thanks,

Dilip

_{Monday, October 13, 2014 6:44 AM}

You have to re-create column. But in that case you loss the information which were already inserted previously in "Date" column. What you can do is : create a feature rcvr which will create a date column now read items from the list and update each item's newly created column(read data from old column and convert to datetime) and then just delete old column if not required.

_{Monday, October 13, 2014 7:01 AM}

Hi

As Rebecca said

you can use a 'soft' solution , changing how your column is displayedTo re-create a new columns as DateTime type, i recommend you to use powershell script to populate the new column with old columns data

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.