Forum Discussion
Now() function is not updating on new item to proper time
So there is no possible way to make a field equal todays date/time consistently? Its not a calculated column, just a Date/Date and Time column with a default value. And it doesn't update when we create a new record.
That seems like a massive oversight by Microsoft. Every other system I know can do this (NAV, BC, Access) I could even write it up in PHP or JS.
Our page might be open for days at a time (we're running a facility and tracking events), and this is a very painful feature because it makes errors in data entry common. If there is a fix i would love to know, else i will have to move to the whole facility to another program.
Its definetly not a problem with performance. the system stores the date, all the system needs to do is access System.Time and retrieve it.
BenHoople you can do it in Power Apps. Or have a flow run once a day just after midnight to update the today's date column with today's date.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)