T-SQL – How to output name of month
The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019 would output March. SELECT DateName( month , GETDATE() ) as…
MONTH
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…
The idiots guide to installing WordPress on DigitalOceans $5 a month plan
I'm not interested in getting into the technical aspects of setting up a VPS as a web server - instead I choose to use DigitalOcean and ServerPilot to get me…
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…
WordPress – How to automatically create sitemap.xml without plugin
The following code will automatically create a sitemap.xml when a post or page is first published. This is a non-plugin way to automatically create the sitemap.xml file - less bloat,…
How to automatically delete entries after a month
The following guide shows how to setup an automatic task that will delete entries older than one month. This may be useful if you do not need to retain entries indefinately…