How to bulk delete Facebook wall posts from your timeline
For years software developers have been fighting to create tools to allow people to bulk delete their Facebook wall posts. Facebook fights back strong - changing their system, and limiting…
YEAR
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…
Crystal Reports – How to calculate financial year from date
The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the Australian financial year which is from July to June, e.g.…
Excel 2016 – How to calculate age from date of birth
The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula will calculate the current age in full years - for…
Why USB flash drives “write protected”
After many years of using USB flash drives I've managed to use one until it's official end of life. Normally drives would be lost long before this point - but…
WordPress – Can I delete the default themes?
Every new install of WordPress comes with a number of themes. But often people install their own theme and wonder if these default themes can be safely removed. The short answer…
SQL – How to select current year from lookup table
The following SQL shows how to select a row from a table using the current year as the WHERE condition. This is useful if you have a table of years…
SQL – How to get current financial year using SQL
The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for your country is 1 July - 30 June. This SQL…
SQL – How to select current financial year from lookup table
The following SQL shows how to select a row from a table using the current financial year as the WHERE condition. This is useful if you have a table of…