May 14 2021 12:22 AM
i have a list column with a date field that i hide when a new item is created.
=if([$Status]=='Pending','false', 'true')
the date field is set to default value "today´s date".
when i create a new item the date field is hidden but when i save it, it writes the wrong time.
the time is always the full hour next (ex. if time is 9:23 it shows 10 ecc.)
whithout the hide formula (date field is visible creating a new item) the time is ok.
what is wrong?
tx for any help
kurt
May 14 2021 10:02 AM
I tried this on my SharePoint tenant & I can reproduce this issue.
Below are my test results, where both dates have default value set to "Today's date":
I will suggest you to see if your regional settings are different than regional settings of SharePoint site.
For more information, check below documentations:
If that does not solve your issue, Contact Office Support or Get support.
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.
May 17 2021 01:56 AM