Archives for December, 2006

Tip: Convert dates stored as text into date values

Posted by Phill on Friday, December 15, 2006 at 8:14 pm. 0 Comments.

This is a tip for SQL server – if you have a database where dates are stored as text and want to convert them all to date values. 1. Create a new column for the date value – columnName_asDate 2. Run the following script UPDATE table_name SET columnName_asDate = CONVERT(DATETIME, RIGHT(columnName, 4) + SUBSTRING(columnName, 3, [...]

Filed under Creating websites.

Bloated Word document headache

Posted by Phill on Wednesday, December 6, 2006 at 1:15 pm. 0 Comments.

A top tip for fixing Word documents that suddenly and inexplicably bloat in size. I was working on a 1.5Mb document that suddenly expanded to 14Mb! The following tip fixed it for me, Jim: "…formatting information, much of it obsolete, is stored in the final paragraph mark of the document. When you go to the [...]

Filed under Lifehacks.