Calculated value based on today’s date in a SharePoint column

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions.  As part of that, I’d like to set a flag on each entry so that it is regularly reviewed – for example every 90, or 180 days.

I had hoped to use a calculated column for this (i.e. today’s date plus x days) but it’s generally recognised that calculated fields only work on data entered by a user, and not from the system. Indeed, Microsoft’s own documentation for the TODAY function says:

“[…] You can use the TODAY function only as a default value; you cannot use it in a calculated column.”

Even so, I’ve had some success (with Microsoft Office SharePoint Server 2007) in setting a column type of Date and Time, in Date Only format, with a Calculated Value of =Today+90.  I’m not sure how/why this is working, given Microsoft’s statement above, but it may be worth considering.  Just be aware that your mileage may vary…

(Christophe Humbert has more information and another approach over at Path to SharePoint)

Towbar 101

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

A few months ago, I mentioned that my new car had been delivered, complete with factory-fitted towbar (incidentally, the instructions to release/retract it are in the handbook, just not under any index heading that might help, such as “towbar”).

Since then, I’ve been having fun with my new 4-bike carrier on the back of the Tig’ (no more piggyback carriers scratching the bikes and the car…) but I did go through a pretty steep learning curve, so I though this post might help other “towing virgins” (except perhaps caravanners).

Firstly, I should clear up that I have no aversion to caravanning (well, actually, I do – particularly when trundling along  behind them on single carriageway roads on a summer Saturday – but that’s not the point here) however, I understand that caravans need extra electricity or something (for fridges, etc.). I was advised at order time that the factory-fit towbar on my car has “single electrics” and so that might be a consideration for those who use a caravan (sadly at least one Skoda-driving-caravan-owner was not given the same advice).  As I have no intention of joining the Caravan Club any time this side of… ever… that’s not a big issue for me but I appreciate that for many it would be…

A trailer might be useful sometimes though, and I already mentioned that my use of the towbar is to carry several bikes on the back of the car (the roof would be another option – but more expensive, and more difficult to lift them on/off).

One thing I quickly found was that, in common with many older trailers, my carrier had a UK-style 7-pin “N type” plug (cf. the 7-pin “S type” used for caravan wiring) and that my car had a 13-pin Euro socket (albeit with just 10 live pins). Halfords sell a suitable converter for under fifteen quid and that did the trick nicely, although I struggled to get it on the first time, it’s become easier over time (full marks to the guys in Halfords, Wellingborough, who were really helpful).  Unfortunately I can’t leave it on the car when not in use as it prevents me from retracting the towbar (no great shakes really).  Those who do have a full set of electrics and who need to tow a house on wheels might find a “spider” adapter useful to split the 13-pin Euro connection into two 7 pin connections (one N and one S, confusingly known as 12N and 12S!).

I found it interesting that the wiring on my car is intelligent enough to disable the rear parking sensors (the display shows a picture of something being towed) and will also sound the alarm if disconnected when the car is locked.  It should also disable the vehicle’s fog lights in preference to the trailer/trailer board’s lights, although I haven’t tested that.  Whilst I sometimes wonder if it might have been less expensive to have an after-market towbar, features like this are a useful side-effect of using a factory-fitted model.

Of course, towing something generally obscures the rear registration plate so I needed to get an extra one (the dealer who supplied the car was happy to oblige there – thanks to Citygate Volkswagen’s fleet sale department) but I needed to drill holes in the plate to mount it on my bike rack.  A few tips that might help here (I picked most of these up from a forum for Vauxhall Vectra enthusiasts):

  1. Start with a small drill.
  2. Use a slow speed (turn town the speed if your drill is variable).
  3. Leave the protective plastic cover on (I started from the front side) until the holes have been made.
  4. Drill through onto a block of wood.

Finally, I got a bit nervous with the bikes on the carrier using just the supplied straps (they are OK for a few miles but I’d be concerned using them for long distance at motorway speeds).  I picked up a 5m ratchet strap (again, from Halfords) and I use this for extra security.  For those who aren’t used to ratchet straps, they can be difficult to get used to but there is a great video on YouTube that might help.

So that’s my top tips for towbar newbies. It’s not complicated, but there was definitely a learning curve involved. If you’ve any tips to add, please leave a comment, although I can’t really support people with their towing questions (especially when it comes to caravans!).

Consumerisation think tank panel at Dell Technology Camp 2012 (#DellTechCamp)

This content is 12 years old. I don't routinely update old blog posts as they are only intended to represent a view at a particular point in time. Please be warned that the information here may be out of date.

Yesterday afternoon, I took part in a panel discussion on the evolution of consumerisation as part of a Dell Technology Camp and in advance of the publication of the third part of Dell/TNS Global’s Evolving Workforce research.  It was the first time I’ve taken part in an event like this and I have to admit I was pretty nervous but it was also an enjoyable experience – particularly given the wonderful surroundings of the Saatchi Gallery in south-west London.  I only wish I’d been able to tweet during the event (I did scribble some notes but was focusing so much on the conversation that tweeting would have been a step to far for this Gen-Xer who isn’t so great at “partial attention”!)

Evolving Workforce Think Tank @ #DellTechCampChaired by Stephen O’Donnell (@stephenodonnell), the discussion examined a number of topics related to consumerisation, including: the generational divide myth; recruiting and retaining talent; new working practices; technology choices; security;controlling costs and driving profit; and the impacts of geography and market sector on progress.

Dell have produced a Storify story about the whole day (not just the panel discussion) – and you can catch the recording of the live stream – but, for those who don’t have a couple of hours to spare, I thought I’d blog the highlights… I guess you could think of them as the tweets that never were:

  • Stephen Yap, TNS UK: It’s a myth that only generation Y gets “social” and consumerisation; TNS’ research finds that older generations are more accepting of IT as a transformation agent (and younger people are more sceptical).  [Something that one of my Baby Boomer colleagues, Vin Hughes, suggested over a year ago in a blog post about the digital world and generational labels.]
  • Alexis Lane, The Head Partnership: Organisations need a element of control to stay within the law, including open communication of policies.
  • Stephen Yap: IT is not just a utility – get it right and it can be a motivator for employees.
  • Mark Wilson (@MarkWilsonIT): The IT department is just a provider of “stuff” in our personal clouds – just like our bank, supermarket, email provider, etc. [Credit is due to Joe Baguley (@JoeBaguley) for that one… also see my post on the rise of the personal cloud, inspired by David Gentle (@DaveGentle).]
  • Helen Calthrop-Owen, Axicom: Consumerisation is part of a bigger change regarding how people work together.
  • Tim Weber (@Tim_Weber), BBC: Policies alone are not enough – citing Joshua Klein (@JoshuaKlein) he says that we need to “hack our work“, noting that it could get you fired, or you could be a big winner.
  • Bryan Jones (@BryanAtDell), Dell: It’s not “lazy IT” that holds us back so much as cultural challenges – the key is to create “competitive differentiation”.
  • Mathias Knöfel (@MathiasContext): Consider the cost factors and end user benefit – given a choice users will pay for flexibility.
  • Mark Wilson: Get under the surface of BYO and you’ll find it’s more about choice – giving users the ability to trade up to a “sexier” device [credit due to Garry Martin (@GarryMartin).]
  • Stephen Yap: Emerging markets see employer-provided devices as attractive (they tend not to have PCs at home); meanwhile in the US/Canada it’s about Bring Your Own Cloud [what I called the personal cloud] – questioning the need for corporate IT. Not so much about the choice of device but working in the way in which we have become accustomed to.
  • Alexis Lane: Increasingly difficult to draw lines of ownership (intellectual property and corporate data vs. life) – often old questions arise in a new context (e.g. the ownership of a contact database cf. LinkedIn profile).
  • Stuart Collingwood, Nivio: Enterprise-grade social media does exist; devices are more emotional and entitlement can create friction (i.e. who is entitled to what); light touch integration is required for end users to access corporate IT.
  • Bryan Jones: There is no silver bullet (in terms of technology); what’s required is a “portfolio discussion” about on premise IT; extrenal service provision (e.g. cloud) and how to bridge the gap.
  • Stuart Collingwood: Employee expectations for IT performance are “brutal”; tolerance of “corporate lethargy” and inflexible applications has dropped.
  • Tim Weber: Users tend to blame devices or applications but may be other issues; legacy holds us back (e.g. network performance).
  • Mark Wilson: Returning to issues of cost – tax implications with benefits in kind – need clearer advice from government.
  • Bryan Jones: The consumer knows what is possible – consumerisation is not solely an IT issue but raises business functional questions. The trick is to simplify IT, to become more responsive – and innovation is occurring whether we like it or not – there’s an opportunity to embrace it and to listen across the organisation, not just to IT.
  • Stephen Yap: There’s a shift towards outcome-based working with an unspoken contract between freedom and blurred boundaries [i.e. no more 9-5] and digital natives find this easier to understand.
  • PJ Dwyer, Dell: Flexible working is popular, but some employees dislike the remoteness/don’t feel part of the team.
  • Tim Weber: In addition to recognition issues, some roles require collaborative working and presence; interesting to see that Twitter (distributed by nature) has triggered Tweet-Ups – the Human Being is a social animal and companies are social organisations; consider team dynamics (e.g. in a large team, others suspicious that they are carrying the load) – management becomes a task of ensuring everyone knows what their colleagues are doing.
  • Marie-Christine Pygott, Context: Communications occur in many ways – if employees are not present, they are not on the mind of others (you can’t walk over to their desk for a chat).
Evolving #Workforce: Does a flexible working policy turn you into a flexible but virtual.. hermit?
@TNS_UK
TNS UK
  • Stephen O’Donnell: We need a virtual watercooler, do we need to use social media to highlight work milestones [or even, “I’m taking the kids to school, I’ll be back in 20 mins”]?
  • Stuart Collingwood: Expect to see that scenario become more common as future generations enter the workplace (and we’re already seeing changing literacy styles, such as use of “text speak” in written English).
  • Carly Tatum, Dell: Communications work in different ways; bringing people into a group situation from social media context can induce a different dynamic [one that doesn’t always work].
  • Mathias Knöfel: Often, meeting people face to face changes the relationship from that point onwards.
  • PJ Dwyer: Emerging markets have different perspectives, due to different stages of development.
Emerging countries leapfrogging with tech as no legacy technology. Getting best tech, big incentive #DellTechCamp
@GStudentAgain
Margo Smale
  • Stephen Yap: In BRIC, for example, skipping PCs and moving straight to smartphones; also leapfrogging legacy in the workplace – not as encumbered.  It will be interesting to see the change as security, etc. become bigger issues in developing nations. Also cultural differences as in some geographies work and technology may act as motivators.
  • Alexis Lane: When talking about the security of information, we need to understand what it is we are protecting. It’s not realistic to say “everything” – what can we be more relaxed about?
  • Tim Weber: The “castle/moat model” makes less sense as we become more mobile and blast more holes in the walls – need to look at data level and see what can be done to protect it; requires clever thinking, supported by technology, to understand how to protect the things that are critical to your company.
  • Stuart Collingwood: We have to think differently about how we build systems – it’s hard (and expensive) to retrofit so we need to re-architect from the ground up.

Graphic Recording from Evolving Workforce Think Tank at #DellTechCamp

Key takeaways

For those who find even that list too much to work through – here are the key takeaways from around the table:

  • Stephen O’Donnell: Consumerisation is happening, it won’t stop – indeed it will accelerate; employees like it, it frees them up from coming to the office as well as from Victorian-style employment contracts; work is becoming more outcome-based; difficult to draw line between work and home; requires serious management – need to think, plan and come up with new ways of thinking.
  • Tim Weber: There is no single solution; every company needs to look at legacy – not just productivity and happy employees but the underlying stategic business model – suss that out and have clarity of thinking to drive company forward; remain flexible as things will constantly change on the roadmap.
  • Mathias Knöfel: BYOD gives opportunities for flexibiity with the right incentives but also risks that need to be thought through more carefully (e.g. legal/risk).
  • Mark Wilson: From an end-user perspective, don’t just think about the “Digital Natives”, also consider “Digital Pioneers” who have seen previous waves of IT transformation and those with no time/inclination too (Digital Luddites); from a management standpoint we need to develop new attitudes to work – become more trusting and results oriented; and the IT department needs to address issues around legacy, removing barriers through innovation and avoiding stagnation; finally, we can’t close lid on this box!
  • PJ Dwyer: It’s happening now; organisations need to be proactive and it affects not just IT but also HR, legal – indeed the whole business. Flexibility and choice are key to success and aspirations vary by market and geography.
  • Marie-Christine Pygott: There are pros and cons to consumerisation – it changes the dynamic of an organisation – the way people work, their flexibility, work/life balance but also who teaches whom – employees suggest more about the technology used; there is no single solution and we need need integrated strategies; communication is vital; also differentiation in different parts of the world.
  • Stuart Collingwood: Consider company culture – not just policy and structural issues – need to instil communications protocols, sensitivities and context within company culture – requires a top down approach.  Culture is safety net and policy handbooks are not enough. People will use technology more responsibly than you might give them credit for.
  • Alexis Lane: Embedding culture of the organisation and taking a decision as to what the company needs to be is important. It’s exciting to consider technology as a motivation – and from a legal perspective we need to get to heart of data issues.
  • Bryan Jones: Not just a technology discussion – people and process too; competitive advantage downstream is enormous; culture is critical to changing the dynamic in a company; it permeates, into how we communicate internally and how we interact with customers.
  • Stephen Yap: Enterprise IT has ever been more exciting than now; we’re at a tipping point, elevating the significance of IT within the organisation and to our lives; not just about IT professionals but it makes a difference to all – in how we work and how we live; not just happy and motivated workers but new business models, new ways of doing things. And the conversations that we’re having are more strategic than 10 years ago; IT is making a bigger difference than ever before.

tl;dr view

Stephen O’Donnell’s summary: there is an enormous opportunity for businesses to adopt and drive the socialisation and consumerisation of IT; to really make a difference in driving down costs, improving agility and improving employee/customer communication. On the other side, there is a risk that we “throw the baby out with the bathwater”, that we don’t follow the processes because it’s all new, that we under manage employees, don’t deal with security appropriately, don’t invest in the underlying infrastructure and so don’t achieve the benefits.

Image credits – Dell’s Official Flickr Page, licensed under Creative Commons Attribution 2.0 Generic (CC BY 2.0). Visual communication/storytelling by Creative Connection.