to change created column type to only date from datetime

Question

_{Tuesday, April 30, 2013 8:19 AM}

Hi,

currently in my document library "created" date column is present. it is showing both date and time in the field.

i want to show only date in the "Created" column and no the time. is it possible??? pls help.. 

All replies (3)

_{Tuesday, April 30, 2013 8:33 AM ✅Answered}

Hi Krishnamurthy

Create a calculation column and use below formula to get date only created column

=TEXT([Created],"dd/MM/yyyy")

Please mark the replies as answers if they help or unmark if not.

_{Tuesday, April 30, 2013 9:27 AM ✅Answered | 2 votes}

create a site column by going to Site Settings -> Galleries -> Site Column -> Then click on create. It will open the New Site Column page. Give a name of the column choose type od Date and Time and choose Date and Time format as Date only and click on OK.

Or

Use Formula

_{Wednesday, April 5, 2017 10:53 AM}

Hi Sir,

How can we implement formula? please suggest.