SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
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 i.e. "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.)
Without hiding the formula (i.e. date field is visible while creating a new item), the time is displaying correct.
What is wrong?
I made test to hide a date and time column in the new form. Set the date and time column default value with Today's Date. Edit the column in the new form to make the date filed not displaying. Still it returns the current time exactly as it is. It works pretty fine in my end. I will suggest you to double check the column settings and share us with the information.
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.
