[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Improve calendar performance in ACT! and other applications

Published on
9,540 Points
1 Endorsement
Last Modified:
Mike Lazarus
Has been in IT since 1980 and CRM for over 30 years. Helping small and medium businesses become more successful through client relationships
Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications.

Most date and time stamps that are created and displayed in Windows and in many applications are stored as UTC. Then, they are rendered in local time by using system APIs. Examples of these include Windows file time stamps, Outlook sent and received dates, and event logging time stamps.

Not all built-in, Windows-based applications use these newly updated APIs. However, they are available to all applications, including third-party applications. These functions are useful in many scenarios, such as a user auditing scenario in which the ability to use DST rules for previous years on a current Windows service pack is important.

Generally, if an application requires historically accurate time stamps, these functions should be used.

This update improves the performance of the functions, and enables historically accurate time-stamp lookup functionality where the application uses these APIs

Tests that have been conducted with an ACT! by Sage database have found loading 16,000 activities reduced in time from 4 minutes to 9 seconds!

The update applies to the following Windows operating systems:

Windows XP Service Pack 3 (SP3)
Windows Server 2003 Service Pack 2 (SP2)
Windows Vista Service Pack 1 (SP1)
Windows Server 2008

You can read more about this update and obtain it from this Microsoft article:
Description of updates to APIs that enable Windows-based applications to retrieve historically accurate time stamps

If you download it, feel free to post here with any tests to verify improvements.

*With thanks to Sage's Benjamin Lederer for directing me to this.

Featured Post

Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Join & Write a Comment

Starting up a Project

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month