Forum Discussion
bob_connelly
Sep 02, 2023Copper Contributor
Set default date/time in SharePoint list with TODAY and a set time
I am hoping to set up a default date and time for a SharePoint List—with the date defaulting to "today" and the time default to 8:00AM. If I use the "Today's Date" option, the time is set to 00:00. ...
- Sep 09, 2023
bob_connelly Use column settings like shown in attached image with this response.
Formula used:
=TODAY()+(8/24)
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
DaveMehr365
Sep 05, 2023MVP
Hello bob_connelly
in my case works the default setting, but i have you the calc formular:
1. Default value:
2. Calculated value
Both works fine:
Best, Dave
bob_connelly
Sep 08, 2023Copper Contributor
In your example, it is showing the current time. I was asking how to give it the current date but a specific time (08:00 AM). Is that possible?
Bob