How to create a date and time column and enter data in a SharePoint List

Question

How to create a date and time column and enter data in a SharePoint List

Abdullah El Tahawy 5

Hi there,

I've created a SP list and I have a time and date column, to fill both date and time SP is giving 2 fields however I saw in another list that both time and date can be entered from a single field.

can you help to explain how can that be accomplished

User's image

Balasubramanian, Karthik Anand 0 Reputation points

2023-10-10T13:01:21.9766667+00:00

Hello there,

This change made to the date and time column in SharePoint has reduced usability due to its poor design and we have been getting complaints from end-users over how the new change degrades the overall user experience.

Upgrades/updates should enhance user experience and functionality, but this latest change does not do that, and it also looks very old in design now.

I would like to know if reverting back to the old design (where both time and date can be entered from a single field) is a possibility as the new one is not very user-friendly.

Thanks,

3 answers

Your answer

Balasubramanian, Karthik Anand 0 Reputation points

2023-10-10T13:01:21.9766667+00:00

Hello there,

This change made to the date and time column in SharePoint has reduced usability due to its poor design and we have been getting complaints from end-users over how the new change degrades the overall user experience.

Upgrades/updates should enhance user experience and functionality, but this latest change does not do that, and it also looks very old in design now.

I would like to know if reverting back to the old design (where both time and date can be entered from a single field) is a possibility as the new one is not very user-friendly.

Thanks,

Answer 1

Yanli Jiang - MSFT 31,666 Microsoft External Staff

Hi @Abdullah El Tahawy ,

I tested in my environment and the situation is the same as yours.

05025

When I use "Edit in grid view" it is like this, but also make date and time selection separately.

05024

In my opinion, it is by design.

Could you please provide me a screenshot of the other list you mentioned? Maybe it used custom code, please check.

Update on 5/3/2023

Regarding the video you provided, I followed his steps to create a Microsoft List using the same template, but, unfortunately, the actual effect is not the same as in the video. When I click to start editing, he will become two parts.

05031

This is an upgrade of the product, and all newly created lists should work in this way.

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.

Abdullah El Tahawy 5 Reputation points

2023-05-02T19:35:45.84+00:00

Hi @Yanli Jiang - MSFT

here's a screenshot of what it looks like. this was taken from the video I've included where a list was created from an existing template which I've followed but the view was different in addition to the behavior of that filed wherein upon clicking inside of the filed it opens the small calendar window where you can pick the date & time.

https://www.youtube.com/watch?v=YpVOS_If-6Q&t=1515s
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-05-03T07:58:04.3533333+00:00

Hi @Abdullah El Tahawy ,

I have updated my answer, please have a check if you have a check out at your convenience.
Abdullah El Tahawy 5 Reputation points

2023-05-04T19:20:45.56+00:00

I don't believe that it's an upgrade of the product. A Sharepoint list that I was using for work had time & date as separate input fields then the creator did something that changed the behavior so that it matched what was in the video. the thing is, the creator of that list doesn't remember how he did it!
Balasubramanian, Karthik Anand 0 Reputation points

2023-10-10T13:02:13.8933333+00:00

Hello there,

This change made to the date and time column in SharePoint has reduced usability due to its poor design and we have been getting complaints from end-users over how the new change degrades the overall user experience.

Upgrades/updates should enhance user experience and functionality, but this latest change does not do that, and it also looks very old in design now.

I would like to know if reverting back to the old design (where both time and date can be entered from a single field) is a possibility as the new one is not very user-friendly.

Thanks,

Answer 2

Yanli Jiang - MSFT 31,666 Microsoft External Staff

Hi @Abdullah El Tahawy ,

I saw your reply, but there is really no OOB way to achieve it at the moment. After some research, you can try to add a Date and Time type column through Power Apps to see if it meets your needs.

Or, by means of development, to customize CSS.

https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-add-js-css-ref

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-05-15T08:31:11.49+00:00

Hi @Abdullah El Tahawy ,

Would you please provide us with an update on the status of your issue after you try the answer?

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 3

Vk 0

How does this work in SharePoint 2013? I have a customized list (Customized using InfoPath) there I don't get this option for selecting time. Please help.I am looking for below option in the form.

User's image

Share via

How to create a date and time column and enter data in a SharePoint List

3 answers

Your answer