Excel – How to calculate the difference between two dates
The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months years days - ignoring years days - ignoring months and…
Format
How to change Local by Flywheel upload limit
By default the file upload limit when using Local by Flywheel is 300 MB. The steps below show how to increase this to 512 MB. Note: The process requires you…
Word – Table won’t paste in new location
Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer you see it was pasted exactly on top of the…
Google Chrome – How to bypass ERR_BLOCKED_BY_XSS_AUDITOR
Problem When trying to submit a form which contains HTML or JavaScript - you receive an error message which reads This page isn't working Chrome detected unusual code on this…
jQuery – How to automatically display images with caption
The following jQuery shows a method I've used to automatically format images with a caption taken from the image ALT tag. This method is useful where you can only insert…
How to install Adobe Reader XI silently using SCCM
The following process shows how to create a silent install of Adobe Reader DC for distributing with a software distribution tool like SCCM. It was last tested with Adobe Reader…
Crystal Reports – How to change text case (lower, upper, title)
Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase - for transforming text to Title Case LowerCase - for transforming text to lower case…
Crystal Reports – How to convert text date to datetime format
Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…
SQL – How to search with accented characters
The following T-SQL for Microsoft SQL Server shows how to search for accented text without having to use the accented characters in the search term. For example, if we had a table…