There is a new article on MSDN that has some useful code samples. This was based off a post by Kerry Westphal on the Access blog a while back. Here is the intro: Many Web 2.0 applications are designed to make it easy to visualize complex data. I found myself recently challenged with this task while working on a project where I wanted to display on a report to show the time elapsed between the current date and another date. Some example scenarios could include how much time has elapsed since a user profile has been updated, the time that remains until taxes are due,
Windows 7 Professional, or how long a library book has been checked out. I did not just want to show the hours or even days elapsed, but something more in sync with the way I want the information given to me─specifically, that when dates are closer to the current date and time they are represented precisely,
Office Home And Business, and dates and times that are farther away are shown generally. I wrote the ElapsedTime user-defined function to accomplish this task. The function can be used in a query to obtain a string that represents the time elapsed. The string returned is either specific or general depending on the length of time elapsed. For example, if the date is close to the current date,
Microsoft Office Standard 2007, it appears as "In 12 hours,
Office 2010 Keygen, 27 minutes". If the date was long ago,
microsoft Office 2010 License, it appears as, "A year ago". The following screen shot shows the results of the ElapsedTime function when it is used to track items in a calendar. <div