Forum Discussion
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.
Is there a way to do this with a calculated value?
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.
4 Replies
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.
ganeshsanap That worked! Thanks!
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
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
