time
10 TopicsWindows regularly changes the time by one minute: what can I do?
Hi all, How to prevent Windows from updating the time? (please read all the text) My windows application developed in for Windows 7/10 & 11, works 7 days a week on a PC that is not connected to the Internet, there is no time server connected to the computer. I developed my application to receive the WM_TIMECHANGE message that is why I notice that I receive this message regularly, at a frequency that seems to depend on the PCs but always with the same offset: 1 minute. My explanation (supposition) would be that Windows maintains a software clock that would shift over time and would update itself when the shift reaches one minute, at least that's what I conclude. Note that this PC is not connected to the Internet and is not on a network. In the event manager, I can find this information in the System item (source=Kernel-General) with the following message: System time changed from 2023-02-08T21:38:00,887702300Z to 2023-02-08T21:39:01.50000000Z. Reason for change: System time synchronized with the hardware clock. Procedure: "" (PID4) This phenomenon that sometimes happens once every 2/3 months, and sometimes every week. This is a big problem for me because I store data as it happens and I timestamp it. How to avoid this automatic clock updating ? - I stopped w32time and even disabled it (w32tm /unregister and net stop w32time) - I've disabled the time synchronisation task in the task scheduler. - I also disabled "Hyper-V Time Synchronisation Service" Nothing helps, Windows changes the time by one minute every ten days or so. Thank you for your help.8.7KViews0likes21CommentsTimespan/duration values in KQL, Power Query and Power BI
In many scenarios event durations are very important. They can be measured in days or in milliseconds and anything in between. In real time analytics it is especially important. In this article I'll describe how such values are treated in KQL and what happens to them when they are brought into Power Query and eventually to Power BI. Finally, I'll provide my recommendation for treating these values in Power BI.6.2KViews3likes0CommentsShared Bookings Page incorrect available timeslots
My Shared Bookings page has started making the times available for things like 12:30 AM to 7:30AM, which is outside the times I have set as the business hours. I made no changes to the page or the services, this just started happening. I have even deleted and recreated a service to see if it would resolve the issue... it didn't. Any help would be most appreciated! Removed Update: The fix I tried did not work. Please help!911Views0likes3CommentsBookings Google Calendar Invite for Appt is in Wrong Time Zone
We have the correct time zone listed for our Microsoft Bookings account and the automated reminder emails show the correct time zone. But when customers use the automated Google Calendar invite, it is showing the wrong time zone for their appointment. It says UTC instead of PST. I believe it is because you have the time zone listed as "(UTC-08:00) Pacific Time (US & Canada)" if you change the wording from UTC to PST I believe it would fix this issue. Google is pulling the first time zone it is seeing which is currently UTC. Please fix this.2.2KViews0likes0CommentsExchange 2019 - Outlook/OWA all messages show the same time 8:02PM
Ok this one has me really puzzled. For some reason, which started randomly (since Feb 2023) the display time in Outlook, OWA and Phones (default app or outlook) have randomly been showing all emails as being received at 8:02PM and sometimes the next day at that time, on every message, could be ones that were sent at 11:02 am, could be ones sent at 2:22pm etc. And seems to have been some but not all users, but now more and more users are affected. All time zone and time syncs are correct. Headers shows the correct time and time zone on the messages. Messagetracking shows correct times as well. I was on Exch 2019, CU12, Nov22SU but did update to the Feb23SU(and all WU) and issue returned. It seems a reboot does fix it for a while. (Did the updates about 5-6 days ago, started again today) No major errors in event viewer other than the following, and that my SSL cert is expiring (in may) MSExchange Front End HTTP Proxy - 1003 [GetActiveCopiesForDatabaseAvailabilityGroup.FindAnotherServerLocatorServer: Server locator number of failovers since 2/22/2023 12:02:42 AM is already 25. No more failover attempts are allowed.] An internal server error occurred. The unhandled exception was: %2 but do not have a DAG The only other odd thing that I see is for some reason there is about 6 Microsoft Exchange certs (4 expire 2023, 2 expire 2026) and I believe there should only be one of those if I look at other setups1.6KViews0likes2CommentsWindows 10 v1909 (19042.1586) Missing Set time zone automatically
A user who recently traveled requested that we setup Windows so that the time zone would update automatically the next time she traveled. In checking our machines (Win 10 v1909 19042.1586) we're noticing that the "Set time zone automatically" option in Settings > Time & Language > Date & Time is missing. Was this feature removed in some version of Windows? If yes, which version and where is it documented? If no, Any thoughts as to why it might be missing? I checked this article "https://docs.microsoft.com/en-us/troubleshoot/windows-client/shell-experience/cannot-set-timezone-automatically" but my "Start" value is already set to "3" and "Value" is already set to "Allow".1.5KViews0likes0CommentsBooking System - SharePoint
I created a Booking System using List of Sharepoint, the requirments are as follow Booking Date: This is set to select the desire Date but not today Date or Past Date "I added the Enforce unique values and add the Column validation for it =[Booking Date]>TODAY() with the message to appear as "The date entered cannot be today or in the past." Booking Time: This is set as (Dropdown List) Morning: 07:00am-03:00pm Evening: 04:00pm -11:30pm All day: 07:00am- 11:30pm Now the requirement is If someone wanted to book Lets say on 31-12-2021 can able to book Morning and if someone/Same Person wanted to book on same day evening time can be done but the Uniqe Value of booking date is the issue, it dont allow double booking and if i removed this uniqe value then many ppl can book at same Day and time. And if someone click one All Day even then no one can book Morning and Evening. If anyone knows how please support, Validation or Java Script. Kindly provide the full details im new to this please. Thanks Inadvance.1.4KViews0likes0CommentsTime and Yes/No
I have a Date/Time Field named "Submitted" in format mm/dd/yyyy hh:mm. I have another calculated field named "HelperTime" with the following formula: =TEXT(Submitted-DATE(YEAR(Submitted),MONTH(Submitted),DAY(Submitted)),"hh:mm") This gives me just the time from the "Submitted" field. I would like to have a calculated Yes/No field that would return the value "yes" if "HelperTime" is greater that 14:00 and "no" otherwise. I am using the following formula but it is not working: =IF(HelperTime>14,"Yes","No") If i use 14:00 in above formula it get an error message.1KViews0likes1Comment