Forum Discussion
Now() function is not updating on new item to proper time
I'm writing this on my phone unfortunately But I have a SharePoint list that has a datetime column. I need the default to equal the current time/date. Should be easy. But I default it to toda...
BenHoople This is the default behavior in SharePoint. When you set the default value of date column to today's date, the value will be updated only when the new item is created (first time only). It does not change everyday or when you update the list item.
Additional:
Same happens with calculated columns as well. Calculated column values are calculated when:
- A new item is created
- An existing item is updated
- Calculated column formula is updated
See my answer given at: Impact on Performance of Calculated Columns
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.