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?
7 Replies
Can you explain the reasons why the time matters if you only need the date?
For all new records, you can set up a Power Automate flow to change the column value to the current date at a specific time, like 12:00 PM.
Best Regards,
Margo
Plumsail team
we have issue with quickparts added to document. example date on the list is 25.01. same date shows inside the document - working fine. but the preview shows day before - always - confirmed with microsoft that there is some mismatch. we found that if there is PM set manually by us it is correct even in the preview.
Do you mean a document created from the template?
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.
