Which date is more understandable by the user?
While the left screen shot is more technically accurate and appeals to the accountant the right screen shot is much more understandable by the user. They also have a button where they can drill down to get the exact date. But really if the unit hasn't had an inspection done in 11 months or needs one in 4 weeks the exact date isn't relevant.
These screen shots are from the form showing all the overdue and upcoming inspections from a client with about 1200 pieces of equipment in the Granite Fleet Manager.
This code was based on the Access team blog entry Constructing Readable Time Elapsed Strings – MSDN article. I had one minor grammatical suggestion which is viewable as community content on the bottom of the MSDN article.
I've seen these kinds of dates on various web sites and had vague thoughts of writing the code but it was way down on my roundtuit list.
Nice stuff. Thanks to Kerry Westphal of MS for creating this.