Denver DataMan Blog

Using Text to Columns to Separate Text in Excel

I found myself with a conundrum when trying to fix dates so they could be imported correctly into a database.  The existing database was exporting dates like this “1943-08-24T00:00:00Z” I need the dates in DD/MM/YYYY format.

The first thing I tried was to use the left function to extract the first 10 characters which gets me the date.  However for some reason the left function would not let me change the output to the right date formula. 

Follow-up from Steamboat Springs Office Session

thank you to everyone who came out for the session.  I am  still researching a way to select a specific cell across multiple sheets with a fornula in Excel.   Please email me if you want me to email you when this post is updated with a solution.  -Steve 

Mobile Friendly Moves SEO on Google

According to Google they will now be looking to how “mobile friendly” your site is to determine your ranking in search. This is a very big departure from other search ranking changes. Denver DataMan will post more information on this topic as it comes available.

Drupal 7.32 critical update: Denver DataMan Response

If you are using Drupal 7, it is vital that you are aware of the latest security update released. Any website running Drupal 7, prior to the .32 release is at serious risk. You might think, my site is small it will not be hacked, unfortunately, however the attack is being completed by an automated tool so all Drupal sites are at risk. The only option is to patch/upgrade your site to the .32 version or higher (when released) of Drupal.