Date only displays in Created Column and want date and time to show

Lorne Andersen 66 Reputation points
2023-01-25T15:47:42.0066667+00:00

I want to see the date and time in the "created" column in Sharepoint. I only see the Date and not the time. How can I correct this.

Microsoft 365 and Office SharePoint For business Windows
{count} votes

3 answers

Sort by: Most helpful
  1. Tasadduq Burney 8,956 Reputation points MVP Volunteer Moderator
    2023-01-25T16:45:51.7933333+00:00

    To display the date and time in the "Created" column in SharePoint, you will need to edit the column settings. Here are the steps to do this:

    1. Go to the SharePoint list or library where the "Created" column is located.
    2. Click on the gear icon in the top-right corner of the page and select "List Settings" or "Library Settings".
    3. Scroll down to find the "Created" column and click on it.
    4. In the column settings, you should see an option for "Date and Time Format". Select the format that includes both the date and time.
    5. Click on "OK" to save the changes.
    6. Now when you view the list or library, the "Created" column should show both the date and time.

    Note that, if you don't see the option to change the Date and Time Format, it might be because the column is a calculated field or it's a read-only field. In that case, you may need to create a new column with the desired format, and then you can use that column instead of the original one.

    Also, if you want the changes to be reflected on all the views of the list, you will need to edit the column in each view.

    1 person found this answer helpful.

  2. Lorne Andersen 66 Reputation points
    2023-01-26T05:05:45+00:00

    Hi Tassadduq - thank you. There is not option to select Date & Time. This "Created" column is a system column by Sharepoint and not one I made.

    User's image

    1 person found this answer helpful.
    0 comments No comments

  3. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    2023-01-26T05:47:47.83+00:00

    You should go to Library settings -> Click Created column in the Columns section -> Set Display Format as Standard.

    User's image

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.