A Timely Reminder

To measure the quality of any data item we need to understand its definition.  Without that, we might totally misunderstand what we're looking at and if we're using the information as the basis for making an important decision the consequences can be dire.

Sometimes it's the presentation of the data that is at fault - take this example:

Date: 07/04/23

What is the date?  The 4th of July or the 7th of April?  And is the year 1923 or 2023?

If we were dealing with a customer database and the field was defined as the customer's date of birth I think we could safely assume that the year was 1923, but spot the same value in a field defined as a mortgage repayment date and the decision could go the other way.  As to resolving which is the day and which the month, we probably all jump one way or another based on what we're used to.  The problem is that the presentation of the date is ambiguous and without a clear definition it is open to misinterpretation.

Confusion over time zones can also cause fun!  I frequently have appointments for telephone calls with people in far away places and coordinating diaries can be problematic.  I know, for instance, that the east coast of North America is usually 5 hours behind UK time, but as we switch from EDT* to EST* and between BST* and GMT* we can be temporarily out of sync.  And why is it that we still change our clocks twice each year?  Is it just to confuse people more?

I was invited to a webinar by another data quality company today.  The invitation said that it would start at 2PM GMT - GMT, what madness is this?  We're in the middle of Summer so our clocks in the UK are all set to BST.  Did they mean that the webinar would start at 2PM, or did they mean it would be an hour later, which, if my brain is in gear, would be 2PM GMT?

It turns out that they were just using GMT as shorthand for UK Time and the event kicked off at 2PM on the dot.  It also finished promptly at 3PM BST - so woe betide anyone who was just logging in then for the scheduled 2PM GMT start!

I try to make a point of using the names of the months when I write out dates - particularly when I correspond with American friends and colleagues.  But is there an easy answer to solving the time zone issue - or should we all switch our clocks to UTC*?

* Glossary
BST - British Summer Time
EDT - Eastern Daylight Time
EST - Eastern Standard Time
GMT - Greenwich Mean Time
UTC - Coordinated Universal Time