Forum Discussion
default time in the Date and Time column
Is there is possibility to change the default Time in the Date and Time column globally?
Example:
That is the default - 12 AM 00
is that possible to change that for anything? even 12PM:00?
So all records under would get something different than 12 AM 00 by default?
3 Replies
SharePoint Online standard library without any form customization or PowerApps. I have around 250 libraries from 60 sites affected potentially in this change...don't think that I can anything regarding this.
Hi — the standard SharePoint column setting can default a Date and Time field to today or a fixed date, but it does not provide a global “use 12:00 PM for every new item” switch. When only a date is supplied, midnight is the normal stored time.
For new items, the clean approach is to customize the list form in Power Apps and set the time controls’ default hour/minute to 12:00, or use a Power Automate flow to replace a midnight value with noon after creation. For existing records, update them separately with Grid view, a one-time flow, or PowerShell after testing on a few items.
Also check the site regional time zone before bulk changes, because SharePoint stores dates in UTC and displays them in the user/site zone. Is this a modern SharePoint Online list, and is the form already customized?
That is the SharePoint Online and there is no relation to PowerApps(no customization of form). Change potentially affects on 70/80 sites with total amount of 260 lists.
