Thursday, 14 May 2020

Give Us Back Our Eleven Days!

Although we are not conscious of it, our world view is built around time; being late for meetings, early for a first date. The time the concert starts, the day of a new term.

In business we are driven by time. Sales are compared to this time last year or last month. We forecast by month or quarter, and year. Dates, times, and time periods are a fundamental building block to how we understand the world. And it is how we measure our businesses.

Yet when you think about it, time is a slippery concept. The idea that events, like sales or profit, occur within a concept we call time, is philosophically tricky. When we talk about time, what do we mean? And what would a world look like that did not include time? If it sounds far-fetched, think again.

A tribe, deep in the Amazonian forest, was found by researchers to have no language for time. Their  language does not have time as a separate entity. There is the time when it is dry, and the time when it is wet. The time when it is dark, or the time when it is light. They do not map events backwards or analyse forwards. Their events are all in the present. Think about it – what if being late was not even a thing? What if planning your career was not a thing? What if you could not miss someone's birthday?

What if you just did what you needed to do, and when you had finished you all relaxed or played sport. Our mental health might be a world away from what it is now.

There are some similarities, however, from a non-time-based culture, to a time-based culture. Day and night are universal, as is getting old. Whether we meet to play sport once work has finished, or at 7pm, the concept is similar. For most of the world, and through most of history, the need to co-ordinate activities with a common and agreed language has been important. It became even more important with the railways. Over centuries our understanding developed, and we developed time zones, and today we measure time very precisely and can be late for anything, anywhere. It is quite an achievement. But it did not come without a cost.

The Julian calendar developed by Julius Caesar was not accurate. Not to the degree of accuracy we enjoy today. In the year 45 BC 80 days was added to the year to bring it back into line with the “real year” of the sun and moon. It was, not surprisingly, dubbed “the year of confusion”.  It also became a political issue, with Emperor Augustus renaming a month after himself (August) and moving a day from February for good measure. It was typical, however, of the difficulty of aligning the calendar, or any calendar, with the reality of the world. The answer turned out to be the Gregorian calendar that we use today, named after Pope Gregory. The only problem was how to move from the Julian calendar to the Gregorian calendar? Just as in the Year of Confusion, it was going to cause, well, confusion ….

It did not just cause confusion, it caused riots. “Popery” was stealing days, rent, and asking for taxes in return. There was a flat refusal to pay taxes for days that did not exist - which is why the UK’s tax year ends of the 5th April. Even more confusingly, Wednesday 2nd September would be followed by Thursday 14th September. I don’t know about you, but the clocks changing twice a year causes a philosophical battle in my head about the meaning of space and time. Imagine the September the 2nd being followed by September 14th, without the days of the week missing a beat. The mathematics and science were awe inspiring, but the practical implementation baffling.

Happily, that is all behind us. Science has turned to more pressing matters like saving humanity. But there are reminders of the time that politicians had to navigate the delicate waters of messing with the people’s calendar. Microsoft SQL Server, which stores data for banks, multi-national businesses, charities, and more besides, includes a data type called datetime. Datetime stores dates from 1-1-1753. 1753 might seem like an arbitrary year, until the stolen days are remembered. Then it is far from arbitrary.

Only historians need to capture data as far back as 1753, or before the Gregorian calendar. But for those who do look backwards, those days are missing as clearly as if it were yesterday. For the rest of us, analysing data by time is normally a more recent exercise. Microsoft Power BI and Excel, for example, have date types that store dates from 1-1-1900.

The story of the calendar, and how some very clever people figured it out is told in a little book called The Calendar by David Duncan. It has more twists than a Dan Brown novel, and in my view a lot more interesting. But that is just me.

Over at the day job blog, I have been writing about analysing data over time using Microsoft Power BI. If you have recently started using this magic bit of software, go have a look. It is complete with all the days, months, quarters and years. From 1900 onwards. Obviously.


  1. Thanks for sharing such huge content keep posting further....outsource medical billing services

  2. Great post. I have learned a lot. Thanks.

  3. Give Us Back Our Eleven Day> This article is very necessary and timely. Very good article. Thank you for telling me about this article. I know of a school & fashion house that has a good education in fashion. Fashion schools in accra madina Riohs Originate is a Creative Art Service and Training Institute in Ghana.
    They provide services and training for individuals/organizations that value their image, style, color and insist on promptness, accuracy and consistency.
    In their course course is tailored and premised on ensuring that students are well grounded in all the basic practical areas of clothing and construction. The core aim is to allow new students unlock their potential in fashion within the shortest possible time.
    Tuition for local students: Gh¢ 4500.
    Tuition for Foreign students: $ 1250.
    Tuition Fees can be paid in 2 installments:
    Local Students-Ghc3500 paid before start of class with the balance Ghc1000 paid during your second month in class.
    Foreign Students-$1000 paid before start of class with the balance $250 paid during your second month in class.

  4. I really want to appreciate the way to write this article.
    It seems that you are very professional and intelligent on the above topics of writing.
    I enjoyed reading your article very much.

    No more waste time to searching #HDimages, #PCwallpaper, #smartphone_wallpaper, #socialmedia_banner, #socialmedia_image_post, #natureHDimages, and many more awesome pictures. Just visit All Awesome Pictures Only For Love Hearts and choose your best choice.

  5. Canzana CBD Don't Miss Out Today's Special Offer. New York, NY - ( NewMediaWire ) - August 22, 2020 - Stress and anxiety have end up inseparable issues of human lifestyles. Males, as well as females, suffer from paintings pressure. Every man or woman has a busy agenda at domestic and workplace. Due to strain and tension, one can't get an excellent quality of sleep every day. Besides, humans can not focus on their work due to anxiety. The calming homes of CBD show development in mental cognizance. It additionally gets rid of stress and tension and improves sleep quality. Canzana CBD Oil is one of the exceptional hemp oils to therapy stress and different intellectual issues.

  6. The very Nice post to read from the interesting article and I really like that one of the interesting content in the post and really helpful for me and for other readers on that website to read that, I am expecting more such kind of posting from the writer So Nice. I know party rentals bethesda md . they provide better service
    party rentals bethesda md