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…
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…
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.…
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…
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…
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…
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…
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,…
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…